This function formats a number and converts it to text.
Syntax
TEXT(value,text)
Arguments
The text argument requires a string. Value requires numeric data or a reference to a cell that contains numeric data.
Data Types
Returns string data.
Examples
TEXT(A1,"$0.00") gives the result $10.00if A1 contains 10
Version Available
This function is available in product version 5.0 or later.
See Also
CHAR | EXACT | Text Functions