Converts a value to text in a specific number format.
Syntax
TEXT(
value,
format_text)
Value is a numeric value, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value.
Format_text is a number format in text form from in the
Category box on the
Number tab in the
Format Cells dialog box.
Remarks
- Format_text cannot contain an asterisk (*).
- Formatting a cell with an option on the Number tab (Cells command, Format menu) changes only the format, not the value. Using the TEXT function converts a value to formatted text, and the result is no longer calculated as a number.
Example
The example may be easier to understand if you copy it to a blank worksheet.