In a Nutshell
The FIXED function in Microsoft Excel is used to format a number as text, with a fixed number of decimals.
Syntax
The syntax for the FIXED function is as follows:
=FIXED(number, [decimals], [no_commas])
- number: The number you want to format.
- decimals (optional): The number of digits to the right of the decimal point. If omitted, it defaults to 2.
- no_commas (optional): A logical value indicating whether to include commas as the thousands separator. If TRUE, no commas are included; if FALSE or omitted, commas are used.