TEXT

The TEXT function formats the value to the given format string.

Syntax

text(value, format)

Arguments

value - The number or reference. Required.

format - The string or format expression. Required.

Example

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

The above formula will return $6,000

Text function

Excel equivalent

Text