FORMAT-NUM

Convert a number to a formatted text value

Syntax

FORMAT-NUM(value, format)

Example

By default, US formatting is applied; the optional culture parameter lets you specify the target format culture.

FORMAT-NUM(4.9675, '00.00')

returns:

04.97

FORMAT-NUM(4.9675, '00.00', 'fr-FR')

returns:

04,97

Notes

Typical format specifiers include:
0 - Replaces with digit or zero if none
# - Replaces with digit or nothing if none
. - Sets the decimal separator position
, - Sets grouping operator position