Formats a number with a fixed number of decimal places.

Sample Usage




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, number will be rounded to the correct number_of_places rather than truncated.
  • suppress_separator - [ OPTIONAL - 0 by default ] - Whether or not 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.


Was this article helpful?
How can we improve it?