Converts the specified numeric value to text, according to the specified format.
Syntax
 Copy Code
|
|---|
TEXT( Number n, Text format ) → Text |
Parameters
- n
- Required. The number to convert.
- format
- Required. The format to use in the conversion.
Remarks
For additional information about the format parameter and formatting in general, check Formatting.
Example
| Formula
Copy Code
|
|---|
=TEXT(A1,"$0.##") |
See Also
Function Reference
N Function
T Function