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:
Syntax: =FIXED(A2,B2,C2)
Result:
Based on the Excel spreadsheet above, the following FIXED examples would return:
Syntax: =FIXED(A3,B3,C3)
Result: 245
Syntax: =FIXED(A4,B4,C4)
Result: 245
Syntax: =FIXED(A5,B5,C5)
Result: 125.000
Syntax: =FIXED(A6,B6,C6)
Result: 245.25
