TEXT()
Syntax. TEXT(value,format_text)
Definition. This function converts a value into text in a specific number format.
Arguments
value (required). A number, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value
format_text (required). A number format, which is one of those in the Custom category box on the Number tab in the Format Cells dialog box
Background. You might need to convert numeric values to text to link static text with calculations. The TEXT() function not only converts numeric values to text but also allows you to use the number formats available in the Format Cells dialog box.
In the format_text argument you can specify custom formats. However, the formats have the following restrictions:
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
