Quick Navigation
FIXED Function
Summary
The Excel FIXED function rounds a number to a specified number of decimal places, formats it with commas as thousand separators, and returns the result as text. Perfect for creating formatted number displays in reports and dashboards.
Syntax
FIXED(number, [decimals], [no_commas])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number | Number |
Yes | Required number to format and convert to text |
| decimals | Number |
No | Optional decimal places. Negative values round left of decimal point. |
| no_commas | Boolean |
No | Optional. TRUE prevents comma separators. |
Using the FIXED Function
FIXED is ideal for generating professionally formatted numbers as text for reports, labels, and dynamic text outputs. Unlike cell formatting, FIXED returns actual text that can be concatenated with other text strings.
Common FIXED Examples
Basic Rounding and Formatting
=FIXED(1234.567,1)Rounds to 1 decimal and formats: 1,234.6
Round Left of Decimal
=FIXED(1234.567,-1)Rounds to nearest 10: 1,230
No Commas
=FIXED(-1234.567,-1,TRUE)No commas, rounds left: -1230
Default 2 Decimals
=FIXED(44.332)Default formatting: 44.33
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Non-numeric value in number argument
Solution: Ensure number argument contains valid numeric data
Unexpected formatting
Cause: Forgetting no_commas parameter includes commas by default
Solution: Add TRUE as third parameter to suppress commas
Notes
- Maximum 15 significant digits per Excel limitation
- Output is always text, not numeric
- Default decimals = 2, default no_commas = FALSE
- Use TEXT function for more formatting options
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+