FIXED

Converts a number into a text string with thousands commas (optional) and with a number of decimal places.

Syntax:

FIXED(number {, digits:number {, no_commas:number}})

Returns the text string given by converting number to text with thousands commas (unless suppressed with no_commas) and with digits decimal places.

Rounding is carried out according to the same formula as that used by the ROUND function.

Example:

FIXED(123456.789, 2)

returns the text string "123,456.79".