FIXED functionAdded by IBM on December 11, 2013 | Version 1 (Original)
|FIXED specifies that a number be displayed with a fixed number of decimal places, with or without a thousands separator. Use this function to apply a uniform format to a column of numbers.
, no thousands separators
number refers to the number to be formatted.
decimals refers to the number of decimal places to be displayed.
no thousands separators (optional) determines whether the thousands separator is used. If the parameter is a number not equal to 0, the thousands separator is suppressed. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your current locale setting are displayed.
The thousands separators are different between different locales. The result is generated in the specific locale (en_us), but for the de locale, the result uses "." as the thousands separator.
Parent topic: List of functions