FIXED(number, precision, commas)

The FIXED function formats a number as text with a fixed number of decimals.

number is the number to be rounded and formatted.

precision specifies how the number is to be rounded. For instance, 2 will round the number to 2 decimal places, while -2 will round the number to 2 places to the left of the point.

commas is a logical value which determines whether the number is to have commas (TRUE) or not (FALSE or omitted).

For example:

FIXED(1234.19999, 2, TRUE)   returns "1,234.20"

FIXED(1234.19999, -2, FALSE)   returns "1200"

See also:

Other text functions