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