Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .