Excel FIXED Function: Syntax, Examples and Tips

Part of the free Module 5: Excel Formulas and Functions · Function 32 of 105 · Full Excel course

The Excel FIXED function rounds a number to a specified number of decimal places and returns the result as text, with or without thousands separators. It is useful when a figure must be embedded in a sentence or label with a consistent number of decimals. Because the output is text, it should not be used in further calculations.

Table of Contents

Syntax

=FIXED(number, [decimals], [no_commas])

Arguments

Argument	Required / Optional	Meaning
number	Required	The number to round and format.
decimals	Optional	Digits to the right of the decimal point. Default is 2. Negative values round to the left of the decimal point.
no_commas	Optional	TRUE removes thousands separators; FALSE or omitted keeps them.

How FIXED works

FIXED rounds using standard half-up rounding, exactly like ROUND, then converts the result to a text string. With no_commas omitted, a value of 1234567.891 becomes 1,234,567.89. The thousands and decimal symbols follow your regional settings, so on a German system the same formula returns 1.234.567,89. The maximum number of significant digits is 15. Negative numbers keep a leading minus sign, unlike DOLLAR which uses parentheses.

Step-by-step example

Type 1234567.891 in A2.
In B2 enter =FIXED(A2). The result is the text 1,234,567.89.
In C2 enter =FIXED(A2,1). The result is 1,234,567.9.
In D2 enter =FIXED(A2,0,TRUE). The result is 1234568 with no separators, which is handy for export files.
In E2 enter =FIXED(A2,-3). The result is 1,235,000, rounded to the nearest thousand.

Practical use cases

1. Consistent decimals in a text summary

="Average score: "&FIXED(AVERAGE(B2:B50),1)

Plain concatenation would show 78.3333333; FIXED trims it to 78.3.

2. Percentages in a sentence

="Growth of "&FIXED(C2*100,2)&"%"

3. Numbers for a system that rejects separators

=FIXED(D2,2,TRUE)

Produces 12345.67 rather than 12,345.67 before pasting into a CSV or ERP import.

4. Rounded headline figures

=FIXED(E2,-6)&" (approx.)"

Turns 48,713,922 into 49,000,000 (approx.) for a dashboard title.

Common mistakes and tips

Using FIXED results in math: SUM ignores text. Keep the raw numbers numeric and use FIXED only in display cells, or convert back with VALUE.
Confusing FIXED with ROUND: ROUND returns a number; FIXED returns text. If you only need rounding, use ROUND or a number format.
Left-aligned results: text aligns left by default. That is a quick visual clue that the cell holds text.
#VALUE! error: one of the arguments is text that cannot be read as a number.
Locale differences: separators come from the system, so a file opened in another country may show different symbols.

FIXED compared with number formatting

Most of the time the right way to control decimals is a cell number format, not a function. Applying the format #,##0.00 to a cell keeps the underlying value numeric, so totals, charts and PivotTables continue to work, and the display changes instantly for a whole range. FIXED is the better choice only when the number becomes part of a text string, when it must be exported as text with a guaranteed number of decimals, or when the result feeds a function that expects text such as TEXTJOIN. The same applies to ROUND: use ROUND when you need a rounded numeric value for further calculation and FIXED when you need a rounded text value for display. Mixing the two, for example summing a column that contains FIXED results, is a common cause of totals that appear too low.