TEXT

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.