TEXT

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

Syntax

text(value, format)

Arguments

value - Required. The number or reference.

format - Required. The string or format expression.

Example

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

The above formula will return $6,000