Syntax
FIXED(number, [decimals], [no_commas])
| Parameter | Description |
|---|---|
| number | Parameter of the FIXED function. |
| [decimals] | (Optional.) Parameter of the FIXED function. |
| [no_commas] | (Optional.) Parameter of the FIXED function. |
Examples
Format price display
Formula
=FIXED(1234.567, 2)
Returns "1,234.57" — rounded to 2 decimal places with comma separator, as a text string.
No commas
Formula
=FIXED(1234567.89, 2, TRUE)
Returns "1234567.89" — the third argument TRUE suppresses the thousands comma separator.
Round to whole number
Formula
="Total: " & FIXED(A1, 0) & " units"
If A1=1523.7, returns "Total: 1,524 units". Rounds to zero decimals and formats with comma for a clean label.
Common Errors
#VALUE!
Occurs if the number or decimals argument is non-numeric text.
#NUM!
Can occur if the decimals argument is excessively large or negative beyond the number's digit count.
Tips
Result is text, not a number
FIXED returns a text string. You cannot do math with the result. If you need a rounded number, use ROUND instead.
Negative decimals
=FIXED(1234, -2) returns "1,200" — negative decimals round to the left of the decimal point, like ROUND.
Building labels
FIXED is ideal for concatenation: ="Revenue: $" & FIXED(B2, 2) produces clean formatted output like "Revenue: $45,230.00".
Try FIXED in Viztab
Import your data and use FIXED with 370+ other formulas. No signup required.
Open Viztab