Excel TEXT Function
Summary
The Excel TEXT function returns a number in a specified 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.
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.