Excel functions / Text
FIXED function
A number as text, rounded to a set number of decimals, with or without commas.
Syntax
=FIXED(number, [decimals], [no_commas])
Arguments
number: The number.decimals(optional): Decimal places (default 2). Negative rounds to tens, hundreds…no_commas(optional): TRUE to leave out the thousands commas (default FALSE).
When to use it
FIXED turns a number into text rounded to a set number of decimals, with thousands separators unless you ask for none. Like DOLLAR, it is for putting numbers into sentences and labels.
Examples
Two decimals with separators
A B C 1 Value 2 1234.567 1,234.57 In C2:
=FIXED(A2, 2)→ 1,234.57No separators
A B C 1 Value 2 1234.567 1234.6 In C2:
=FIXED(A2, 1, TRUE)→ 1234.6
Common mistakes
- The result is text. FIXED gives text. Keep the number in a number format if it will be used in other formulas.
FIXED in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: ZAOKROUHLIT.NA.TEXT
- Danish: FAST
- Dutch: VAST
- Finnish: KIINTEÄ
- French: CTXT
- German: FEST
- Hungarian: FIX
- Italian: FISSO
- Norwegian: FASTSATT
- Polish: ZAOKR.DO.TEKST
- Portuguese (Brazil): DEF.NÚM.DEC
- Portuguese (Portugal): FIXA
- Russian: ФИКСИРОВАННЫЙ
- Spanish: DECIMAL
- Swedish: FASTTAL
- Turkish: SAYIDÜZENLE