How to use TEXT Functions in Excel?

[board-infinity]

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.

Syntax

=TEXT (value, format_text)

Arguments

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

Example:

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"