Returns a number as text with a specified format.


FIXED(number, decimals, omitseparators)
returns text representing number with decimals decimal places. If omitseparators (optional) is TRUE thousands separators will be omitted. In the absence of omitseparators thousands separators are included.


FIXED(1234567.89, 3)
returns 1,234,567.890 as text, if your locale uses a comma as the thousands separator.
FIXED(1234567.89, 3, TRUE)
returns 1234567.890 as text.

Created with Zapof