TEXT

Convert a number to text in a number format

Sponsored Link

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.
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.

Sponsored Link

0 votes. 0 / 5