Summary

The Excel FIXED function rounds a number and returns the result as text. For example, =FIXED(1234.567,2) returns "1,234.57". The value looks numeric, but Excel treats it as text.

This is the main difference between FIXED and ROUND. ROUND returns a number you can still calculate with. FIXED returns formatted text, so it is better for labels, messages, or exported strings where the appearance matters more than further calculation.

Syntax

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

The first argument is the number to format. The second sets how many decimal places to keep. The third controls whether commas appear in the result. If you omit decimals, Excel uses 2. If you omit no_commas, Excel keeps the commas.

Arguments

• number - [Required] The value you want to round and format.
• decimals - [Optional] The number of decimal places to show. The default is 2. Negative values round to the left of the decimal point.
• no_commas - [Optional] Use TRUE to remove thousand separators. Use FALSE, or leave it blank, to keep them.

FIXED vs Other Functions

Use FIXED when you need a formatted text result. Use ROUND when you need a rounded number. Use TEXT when you need a custom format pattern. Use DOLLAR when you want a currency symbol added automatically.

Using FIXED

FIXED is useful when the displayed format must stay consistent. If you join a number directly with text, Excel may show too many decimals or drop trailing zeros. FIXED avoids that by forcing the result to a fixed format.

For example, ="Size: "&FIXED(C1,1) always returns a one-decimal label such as "Size: 10.6". The same idea works for reports, exported text, and display fields.

• Use FIXED when the final result should be text, not a number.
• Use no_commas = TRUE when commas should be removed from the output.
• Use ROUND instead if the result still needs to be used in later math.

Example 1 - Formatting a Number to Two Decimal Places

This is the standard use of FIXED. Excel rounds the number, adds comma separators, and returns a text result with exactly the decimal count you requested. If you ask for more decimals than the source value has, Excel adds trailing zeros.

=FIXED(1234.567, 2)  // "1,234.57"
=FIXED(1234.567, 4)  // "1,234.5670"
=FIXED(1234.567, 0)  // "1,235"

Example 2 - Removing the Comma Separator

The third argument controls comma separators. This matters when the output needs to stay plain, for example in exported text or systems that should not receive values like "5,000.00".

=FIXED(5000, 2, FALSE)  // "5,000.00"
=FIXED(5000, 2, TRUE)   // "5000.00"

Example 3 - Getting a Whole Number as Text

When decimals is 0, FIXED rounds to a whole number and still returns text. That means the result may look like a normal integer, but it behaves like text unless you convert it back.

=FIXED(99.9, 0)   // "100"
=FIXED(99.1, 0)   // "99"

Example 4 - Embedding a Formatted Number in a Sentence

This is where FIXED is often the better choice than ROUND. The number is already in the exact display format you want, so when you join it with text, the label stays consistent.

="Size: "&FIXED(C1,1)         // "Size: 10.6"
="Weight: "&FIXED(A1,3)&" kg" // "Weight: 1,234.567 kg"

Remember that FIXED returns text. If you sum, average, or compare the result later, you may get text-related behavior instead of numeric behavior. In that case, keep the original number for calculations and use FIXED only at the display step.

• FIXED returns text, not a real numeric result.
• ROUND is better when the rounded value will be reused in calculations.
• TEXT is better when you need a custom format instead of a simple decimal setting.

Conclusion Recap

• Summary: FIXED rounds a number and returns formatted text.
• Syntax: =FIXED(number, [decimals], [no_commas]).
• Key point: The result is text, so it is mainly for display.
• Practical usage: Labels, report text, and exported values with a consistent decimal format.
• Best rule: Calculate first, then apply FIXED at the final display step.