I. Intro
The FIXED function can be used to specify the number of decimal places to show for the specified number.
To use this function, enter =FIXED in a cell, or click Menu > Data > Formulas > Text > FIXED in the toolbar. Enter the arguments and press Enter.
II. About the function
- Formula: =FIXED(number, [number of places], [suppress_separator])
- Arguments:
- number (required): The number for which you want to format.
- number of places (optional): The number of decimal places you would like to show in the results. When omitted, two decimal places will be used.
- suppress_separator (optional): Sets whether to use thousands separators. If this value is 0, FALSE, or is omitted, thousands separators will be used. If this value is not blank (including 1, TRUE, or any non-blank value), thousands separators will not be used (For example, 1,000 would be expressed as 1000).
- Examples