Excel TEXT Function

Excel TEXT Function

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.

Usage notes 

Use the TEXT function to convert a number to text in a specific number format.

TEXT is especially useful when you want to embed the numeric output of a formula or function and present it in a particular format inside other text. For example, “Sales last year increased by over $43,500”, where the number 43500 has been formatted with a currency symbol and thousands separator.

format_text must appear in double quotation marks.

To see examples of number formats that are available, consult the Format Cells dialog box.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas