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.