The TEXT function formats the value to the given format string.
text(value, format)
value - Required. The number or reference.
format - Required. The string or format expression.
text(6000,"$###,###.00")
The above formula will return $6,000
Last updated 3 years ago
Was this helpful?
