TEXT

The TEXT function converts a value into formatted text based on the specified format string. This function is commonly used to display numbers, currencies, percentages, and dates in a specific format.

Syntax

TEXT(value, format)

Arguments

• value: The number or reference to format.
• format: The format string or format expression to apply.

Return value

Returns the formatted value as text.

Example

TEXT(6000, "$###,###.00")

Returns $6,000.00.

Excel equivalent

TEXT