FIXED

Formats a number with a fixed number of decimal places.

Sample usage

FIXED(3.141592653,2)

FIXED(966364281,4,1)

Syntax

FIXED(number, [number_of_places], [suppress_separator])

• number – The number to format.

• number_of_places – [ OPTIONAL ] - The number of decimal places to display in the result.

  • If number has fewer than number_of_places significant digits, zeros will be appended. If it has greater than number_of_places significant digits, the number will be rounded to the correct number_of_places rather than be truncated.

• suppress_separator – [ OPTIONAL – 0 by default ] – Whether to suppress the thousands separator used in some locales (e.g. 1,000 becomes 1000). Separators will be present if this value is 0 or omitted, and absent otherwise.

Examples