The Excel FIXED function converts a number to text with fixed number of decimals, rounding as needed. The FIXED function can be useful when you want to concatenate a formatted number with other text. Note: the TEXT function is more flexible and can apply many different number formats.
Syntax: =FIXED(number, [decimals], [no_commas])
The FIXED function syntax has the following arguments:
- Number (Required): The number you want to round and convert to text.
- Decimals (Optional): The number of digits to the right of the decimal point.
- No_commas (Optional): A logical value that, if TRUE, prevents FIXED from including commas in the returned text.
Example: Let’s look at some Excel FIXED function examples and explore how to use the FIXED function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following FIXED examples would return: