How to Use the FIXED Function in Excel

The Excel FIXED function rounds a number and returns the formatted result as text. Use it when you need display-ready text inside a formula. For numbers that must remain available for calculation, use ROUND or cell formatting instead.

Syntax

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

• number: the number to round and convert to text.
• decimals: optional number of decimal places. The default is 2. A negative value rounds to positions left of the decimal point.
• no_commas: optional logical value. TRUE suppresses thousands separators; FALSE or omission includes them according to Excel's locale formatting.

Examples

Assume A1 contains 5123.591.

The exact thousands and decimal separators follow regional settings, so the displayed punctuation can differ from these examples.

Why the result may not calculate as expected

FIXED returns text. A formula such as =FIXED(A1,2)+B1 can rely on implicit conversion or fail depending on the values and Excel context. Do not use formatted text as the main numeric data for totals, averages, or comparisons.

Keep the source numeric and use one of these alternatives:

• =ROUND(A1,2) to return a rounded number.
• Home > Number formatting to change appearance without changing the stored value.
• TEXT(A1,"#,##0.00") when you need a more customizable text format.

Format currency without converting to text

Select the cells and choose a Currency or Accounting format from the Number group on the Home tab.

This preserves numeric values for later calculations. Formatting only changes what users see; ROUND changes the calculated numeric value, and FIXED returns text.

Common errors

• #VALUE!: number or decimals contains text that Excel cannot convert. Check imported data and remove hidden characters.
• Unexpected separator: regional settings control comma and decimal symbols.
• Unexpected zeros: decimals controls the text's fixed number of displayed decimal places.

Compare truncation with rounding in the TRUNC function guide. For conditional counting rather than formatting, see the COUNTIF guide.