Excel ROUND Function Not Working? Fixes to Try

Your Excel ROUND function usually appears not to work because the value is stored as text, the formula has a syntax or argument-separator problem, or the cell is only formatted to display fewer decimals. Check the formula, confirm the input is a number, and distinguish the calculated value from its on-screen display; those checks resolve most cases.

Common reasons ROUND seems broken

ROUND changes a number’s value to a specified number of digits. It does not merely hide digits, and it does not always behave the way people expect when the underlying input is text, a formula returns an unexpected value, or a cell’s number format masks the result. Start by identifying which of these situations applies.

The formula is malformed: a missing equals sign, misspelled function name, unmatched parenthesis, or wrong argument separator can prevent Excel from calculating it.
The input is text: a value that looks like 12.345 may have been imported or entered as text, so Excel cannot treat it as the numeric input you intended.
The cell only looks rounded: number formatting can show two decimal places while retaining additional digits in the stored value.
The formula uses the wrong number of digits: the second argument controls the rounding position, and a negative value rounds to the left of the decimal point.
Excel has not recalculated: if calculation is set to Manual, a formula may show an old result until the workbook recalculates.

These causes have different fixes. For example, changing a cell’s number format will not repair a text value, and retyping a formula will not change the number of decimal places merely displayed by formatting.

How Excel ROUND works

ROUND takes two arguments: the number to round and the number of digits to round to. With a positive second argument, it rounds to decimal places; zero rounds to a whole number; a negative argument rounds to tens, hundreds, or larger place values. Excel rounds a midpoint away from zero: for example, 2.5 rounds to 3, while -2.5 rounds to -3.

With the number 12.345 in A2, this formula rounds to two decimal places:

With 12.345 in A2, the formula =ROUND(A2,2) returns 12.35.

The second argument is not a request for a minimum number of visible digits. It tells Excel what place value to use in the calculation. If you use 2, Excel rounds to hundredths; if the result is 12.3, the displayed result may still omit a trailing zero unless you apply a number format.

A negative digit count is valid and often mistaken for an error. With 1,234.567 in A2, the formula =ROUND(A2,-2) returns 1,200, rounding to the nearest hundred. With the same input, =ROUND(A2,0) returns 1,235. The minus sign belongs in the second argument, not in front of the whole function.

Check the formula and argument separator

A ROUND formula must begin with an equals sign when entered as a formula. Check that the function is spelled ROUND, that both arguments are inside the parentheses, and that the second argument is a number or a cell reference containing a number. For instance, with the value in A2 and the desired decimal count in B2, =ROUND(A2,B2) uses B2 as the digit count.

In many English-language Excel installations, a comma separates function arguments. Some regional configurations use a semicolon instead. If Excel rejects a formula that appears correctly written, use the separator expected by your installation; the exact choice depends on regional settings. Do not confuse that argument separator with the decimal symbol. A locale may use a comma as the decimal symbol and a semicolon between arguments.

Look at the error or behavior for clues:

#NAME? often means Excel does not recognize part of the formula, such as a misspelled function name or text entered without quotation marks where a formula expects a name or value.
#VALUE! can indicate that an argument is not a usable number, including text that cannot be converted as expected.
The formula appears as text: the cell may be formatted as Text, or the entry may begin with an apostrophe. Excel then displays the characters instead of calculating them.
A result appears unchanged: the input may already be rounded at that position, or the number format may conceal the difference.

To repair a formula entered in a Text-formatted cell, change the cell’s number format to General, then edit and confirm the formula again. Merely changing the format after entry may not make Excel reinterpret the existing text automatically.

Make sure the input is a real number

Imported data, copied web tables, and values with leading apostrophes can look numeric while being stored as text. One clue is that Excel may align the value differently from nearby numbers, though alignment can be customized and is not conclusive. You can also select the cell and inspect the formula bar, or test whether Excel treats the value as numeric before troubleshooting ROUND itself.

With the suspected input in A2, =ISNUMBER(A2) returns TRUE if Excel recognizes A2 as a number and FALSE if it does not. If the result is FALSE, examine how the data was imported and whether it contains spaces, currency symbols, or a decimal separator that does not match the workbook’s regional conventions.

For a value typed directly into a cell, remove any leading apostrophe and enter it again as a number. For imported columns, use a deliberate conversion method appropriate to the source and locale rather than blindly replacing punctuation: changing a decimal comma to a decimal point, for example, could alter the intended value. After conversion, verify a few representative entries and confirm that ROUND returns the expected result.

Separate rounding from number formatting

Formatting changes what Excel displays, not necessarily the number stored in the cell. A value such as 4.678 can be formatted to show 4.68 while remaining 4.678 for later calculations. If a total uses the stored values, it may therefore differ slightly from a total calculated from values that were actually rounded with ROUND.

To inspect the underlying value, select the cell and look in the formula bar, or increase the displayed decimal places using the decimal-place controls in Home > Number. To change only the display, select a number format with the desired decimal places. To change the value used in later calculations, use ROUND in the formula. These are different operations, so choose based on whether downstream calculations should use the rounded amount.

For example, with 4.678 in A2, the formula =ROUND(A2,2) returns the numeric value 4.68. Applying a two-decimal display format to A2 can show 4.68 without changing A2’s stored value. If another formula depends on the unrounded A2, it still sees 4.678. This distinction is a common reason a displayed figure appears right while a sum or comparison seems wrong.

Choose the right rounding function

ROUND rounds to the nearest specified digit. If your requirement is always to move away from zero or always toward zero, use a different function rather than expecting ROUND to apply a one-way rule. With 12.341 in A2, =ROUNDUP(A2,2) returns 12.35, while =ROUNDDOWN(A2,2) returns 12.34. ROUNDUP and ROUNDDOWN act on the magnitude of the number, so negative inputs also move away from or toward zero respectively.

Do not confuse these functions with the CEILING and FLOOR family, which round to a specified multiple rather than simply to a chosen decimal position. The choice depends on the rule you need: nearest cent, always up to the next tenth, or nearest multiple of five are different instructions. Write down the intended rule in ordinary language before replacing ROUND with another function.

Also note that Excel stores many decimal fractions using binary floating-point representation. Some calculated values can therefore contain tiny internal differences from the decimal value suggested by their display. This can affect edge cases in long calculation chains. If a later step must use a defined decimal precision, apply ROUND at that point and check the source calculation; changing display formatting alone does not remove internal precision.

Check calculation mode and formula display

If a ROUND formula is correct but its result does not update after the input changes, check calculation mode. In Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options and select Automatic. In Excel for Mac, use Formulas > Calculation Options > Automatic as well. A workbook set to Manual calculation can retain previous results until recalculation is requested.

Another possibility is that Excel is showing formulas rather than results. Check Formulas > Show Formulas. If that option is on, formula cells display their expressions in the worksheet, which can look like Excel has failed to calculate. Turn it off to return to the normal result view. Also check whether the formula cell is formatted as Text, especially if only one cell is affected while neighboring formulas work.

When a formula refers to other cells, verify those references too. A correct ROUND function can return an unexpected result because it points to the wrong row, includes a blank or text cell, or receives an intermediate value different from the one you expected. Select the formula cell and inspect its references; then compare the source cells’ actual values with their displayed values. Fixing the input or reference is usually better than adding extra rounding to disguise the issue.

Frequently Asked Questions

Why does Excel show the ROUND formula instead of an answer?
Check whether the cell is formatted as Text, whether the entry begins with an apostrophe, and whether Formulas > Show Formulas is enabled. If the cell was Text-formatted when you entered the formula, change it to General and re-enter or reconfirm the formula.

Why does ROUND not change my number?
The input may already be rounded to the requested place, or the displayed number may hide a smaller difference. Check the underlying value in the formula bar and confirm the second argument: zero rounds to a whole number, while a positive value rounds to decimal places.

Why is my ROUND result different from what I see in the cell?
The displayed value may be formatted to fewer decimal places than the stored value. Increase the displayed decimal places to inspect it, and use ROUND in the calculation if later formulas must use a rounded value rather than a display-only approximation.

Can ROUND use a negative number of digits?
Yes. A negative second argument rounds to the left of the decimal point. For example, with 1,234.567 in A2, =ROUND(A2,-2) returns 1,200, the nearest hundred.

Should I use ROUND, ROUNDUP, or ROUNDDOWN?
Use ROUND for the nearest value at the chosen precision. Use ROUNDUP when the result must move away from zero, or ROUNDDOWN when it must move toward zero. If you need to round to a particular multiple, choose a suitable CEILING or FLOOR function instead.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.