Returns a text string converted from a value using a specified style format.
Syntax:
TEXT( value:Number or 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
.
Revisions:
Starting with 2.30, this function can now automatically convert OpenDocument / Microsoft Excel-compatible serial numbers to date values if a date format is supplied.