How to use TEXT Functions in Excel?

The Excel TEXT function returns a number in a given number format, as text. You can use the TEXT function to embed formatted numbers inside text.

  • Purpose: Convert a number to text in a number format
  • Return value: A number as text in the given format.


=TEXT (value, format_text)


  • value - The number to convert.
  • format_text - The number format to use.


With the date July 1, 2021 in cell A1, the TEXT function can be used like this:

=TEXT(A1,"dd-mmm-yy") // returns"1-Jul-2021" =TEXT(A1,"mmmm d") // returns "July 1"