What FIXED does
FIXED rounds a number to a chosen number of decimal places, formats it as text, and can optionally remove comma separators. It is useful when you need consistent text output rather than a numeric cell format.
Practical examples
Round to one decimal place
=FIXED(A2,1)This returns a text version of the rounded number with one digit after the decimal point.
Remove comma separators from the text result
=FIXED(A3,-1,TRUE)This rounds to the left of the decimal point and returns the result without commas.
Common mistakes and notes
FIXED returns text, not a number
That matters if you later try to use the result in math functions. Format the original cell instead if you only need a visual display change.
Negative decimals round to the left of the decimal point
For example, -1 rounds to tens, -2 rounds to hundreds, and so on.