FIXED function
FIXED rounds a number and returns it as text with thousands separators. It works like DOLLAR but without a currency symbol, and defaults to two decimals.
Example
Read it as a sentence: round 1234.567 to 1 decimal place and show it as text with a thousands separator, which gives 1,234.6.
A
B
C
D
1
1,234.6
2
3
Syntax
FIXED(number, [decimals], [no_commas])
Arguments in [square brackets] are optional.
-
number(required) - The number to round and format.
-
decimals(optional) - Digits after the decimal point; default 2.
-
no_commas(optional) - TRUE to leave out thousands separators.
Returns: Text showing the rounded number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=FIXED(1234.567) | 1,234.57 | Default |
=FIXED(1234.567,1,TRUE) | 1234.6 | No commas |
=FIXED(1234.567,-2) | 1,200 | Negative decimals |
=FIXED(-0.5,0) | -1 | Rounding negative half |
=FIXED("12.345",1) | 12.3 | Text number |
=FIXED("a") | #VALUE! | Bad text |
=FIXED(1234.5,128) | #VALUE! | Decimals past 127 |
Watch out for
- Result is text.
- Default is two decimals, not zero.
Where it works
- Excel
- FIXED is in every version of Excel from 2007 on.
- Google Sheets
- No direct equivalent. Use TEXT(number,"#,##0.0").
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .