TEXT

Returns a text string converted from a value using a specified style format.

Syntax:

TEXT(value:(number|date), format:text)

Returns a text string of the value in the style specified by the format text string.

value must be either a number or date and/or time value.

format is a text string in Fireworkz number format style.

Example:

TEXT(7123.456, "£#,###.00")

returns £7,123.46.