TEXT

Converts the specified numeric value to text, according to the specified format.

Syntax

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

=TEXT(A1,"$0.##")

See Also

Function Reference
N Function
T Function