Excel ROUND Function Not Working? Causes and Fixes

If Excel’s ROUND function seems not to work, first check whether the cell contains a real number and whether the formula is actually being calculated; then check the result’s number format. With a number in A2, for example, =ROUND(A2,2) rounds it to two decimal places, but a cell format can hide that change or text stored as a number can prevent the expected result.

Start with the quickest checks

Look at the formula bar and the displayed value before changing the workbook. If you see the formula itself in the cell, Excel may be treating the entry as text or showing formulas instead of results. If you see a result with unexpected decimal places, the cell’s number format may be responsible. If the formula is correct but the result is stale, check calculation settings.

Try these checks in order:

Confirm the entry begins with an equals sign and that the cell is not formatted as Text.
Verify that the referenced cell contains a numeric value, not a number saved as text.
Check the number of decimal places in the formula and in the cell’s display format.
Set calculation to Automatic if formulas are not updating.
Look for an error such as #VALUE! or #NAME?, which points to a different problem than incorrect rounding.

These checks distinguish a formula problem from a display problem. They also help avoid changing source data unnecessarily when only the way Excel shows the result needs attention.

How the ROUND function works

ROUND uses two arguments: the value to round and the number of digits to keep. A positive digit count rounds to decimal places, zero rounds to the nearest whole number, and a negative digit count rounds to the left of the decimal point. The value being rounded can be a cell reference, a calculation, or a number entered directly.

With the value 8.276 in A2, this formula returns 8.28:

With 8.276 in A2, the formula returns 8.28: =ROUND(A2,2)

With 8.276 in A2, the formula returns 8: =ROUND(A2,0)

With 1,276 in A2, the formula returns 1,300: =ROUND(A2,-2)

Excel rounds midpoint values away from zero. For example, with 2.5 in A2, the formula returns 3: =ROUND(A2,0). With -2.5 in A2, the same formula returns -3. This behavior matters when comparing Excel rounding with another system that uses a different rule for exact halfway values. For ordinary decimal approximations, the stored binary value can also affect whether a number is precisely at a midpoint.

When a formula references another formula, ROUND acts on the value returned by that formula. It does not change the source cell or permanently alter the underlying data. If you need a rounded value for later calculations, use the rounded result in those calculations rather than relying only on how a cell looks.

Displayed decimals are not the same as rounded values

A common source of confusion is number formatting. Formatting can show fewer decimal places without changing the value Excel stores. For instance, a cell containing 3.456 may display as 3.5 when formatted to one decimal place, while calculations that reference it still use 3.456. The reverse can happen too: a ROUND formula may return 3.46, but a format that shows zero decimal places will display 3.

To inspect or change the display, select the cell and use Home > Number. The Increase Decimal and Decrease Decimal buttons change how many decimal places are shown. For more control, press Ctrl+1 on Windows to open Format Cells and choose a category such as Number. On Mac, use Command+1 to open Format Cells. These actions change presentation, not the value returned by ROUND.

To separate the two questions, click the result cell and inspect the formula bar: it shows the stored result or formula, while the grid shows the formatted display. If calculations must use a rounded amount, put ROUND in the formula. If the goal is only to make a report easier to read, number formatting may be enough. In financial or scientific work, make that distinction explicit so that readers know whether later calculations use exact source values or rounded ones.

Check calculation mode and formula entry

Excel can be set to Manual calculation, in which case formulas may not recalculate immediately after source values change. In Microsoft 365 for Windows, select Formulas > Calculation Options > Automatic. If the workbook uses Manual mode intentionally because it contains many calculations, press F9 to calculate open workbooks. On Mac, calculation settings are available under Formulas > Calculation Options; the exact menu presentation can vary with the Excel release. F9 is the usual recalculation shortcut on Windows, while Mac keyboards may require Fn+F9 depending on keyboard settings.

When the cell displays the formula text instead of a result, check whether Show Formulas is enabled under the Formulas tab. The Windows shortcut Ctrl+` toggles formula display; on some keyboards the backtick key is in a different position. On Mac, use Formulas > Show Formulas if the shortcut differs. Also check for a leading apostrophe or a Text number format. Change the cell to General, edit the entry, and press Enter so Excel interprets it as a formula. Merely changing Text to General after entry may not convert the existing content.

Numbers stored as text and imported data

Values pasted from websites, CSV files, accounting systems, or other workbooks may look numeric but be stored as text. ROUND expects a number; text input can produce #VALUE! or fail to behave as expected in a larger formula. Common clues include a green error indicator, left-aligned values in a General-format cell, leading or trailing spaces, and an apostrophe before the digits. Alignment alone is not conclusive because formatting can override it.

First try selecting the affected cells and using the warning icon’s Convert to Number option, if Excel offers it. You can also use Data > Text to Columns and finish the wizard to convert clean numeric text, or remove unwanted spaces and re-import the source. Check decimal and thousands separators as well: a value copied with a comma decimal mark may not parse as expected under a different regional setting.

If A2 contains text that represents a number in a format Excel can interpret, this formula converts it and rounds the result to two decimal places: =ROUND(VALUE(A2),2)

With the text value 14.237 in A2, the result is 14.24. VALUE is not a universal cleanup tool: unusual currency symbols, nonbreaking spaces, or separators inconsistent with the computer’s regional settings may need to be cleaned first. For a large imported range, fix the source or convert the column rather than hiding a data-quality issue inside every calculation.

Understand errors and common formula mistakes

Different symptoms point to different causes. #VALUE! often means that an argument is not a usable number. #NAME? can indicate a misspelled function name, missing quotation marks around text in a formula, or a name Excel does not recognize. A formula that is accepted but returns an unexpected value is more likely to involve the wrong reference, digit count, or data type.

Check that the second argument is the number of decimal places, not the desired number of significant digits. For example, a digit count of 2 means two places after the decimal; it does not mean two significant figures. Also inspect references after copying a formula. A relative reference such as A2 changes as the formula is filled down, while an absolute reference such as $A$2 stays fixed. Use absolute references only when the calculation genuinely needs the same input each time.

In a typical English-language Excel installation, formulas use commas between arguments. Some regional settings use semicolons instead. If Excel rejects a correctly written formula, check the list separator configured for your locale and use the separator Excel expects. This is a parsing issue, not a change to what ROUND does. Function names may also be localized in some language editions.

Floating-point precision and repeated rounding

Excel stores most decimal fractions using binary floating-point representation, so some decimal values cannot be represented exactly in memory. A calculation that appears to produce a clean halfway value may therefore be slightly above or below it internally. This can explain surprising results in edge cases, especially after several arithmetic operations. It does not mean every apparent rounding issue is caused by floating-point precision; check formatting, references, and input types first.

Excel generally keeps about 15 significant decimal digits of precision for numeric values. That limit is separate from the number of decimal places displayed. A formula can show two decimals while retaining more precision in its underlying calculation, unless ROUND is used to return a rounded value. Avoid the workbook setting called Set precision as displayed unless you understand its consequences: it can permanently discard precision from stored values, and changing the setting later does not restore lost digits.

For a calculated amount based on a value in A2, this formula rounds the computed product to two decimal places: =ROUND(A2*1.075,2)

With 10.00 in A2, the calculation is 10.75 and the result is 10.75. Be deliberate about where rounding belongs. Rounding each intermediate step can produce a different total from keeping precision through the calculation and rounding only the final result. The appropriate method depends on the rules of the task or reporting system; do not assume that formatting alone applies the required rounding rule.

Choose the right rounding function

ROUND is for rounding to the nearest specified place. If the requirement is always to move away from zero, use ROUNDUP; if it is always to move toward zero, use ROUNDDOWN. For example, with 4.231 in A2, ROUNDUP to two decimal places returns 4.24: =ROUNDUP(A2,2). With the same value, ROUNDDOWN returns 4.23: =ROUNDDOWN(A2,2). These are not interchangeable with ordinary nearest-value rounding.

MROUND rounds to the nearest multiple, which is useful when the target is a step size rather than a decimal place. With 17 in A2, the formula returns 15, the nearest multiple of 5: =MROUND(A2,5). If the value is exactly between two multiples, check the function’s midpoint behavior and confirm that it matches the requirement. For a custom rule, spell out the rule in a separate calculation rather than assuming ROUND handles every convention.

Before choosing a function, ask what the result must mean: nearest decimal place, always up, always down, or nearest increment. Also consider whether negative numbers are possible, whether midpoint values occur, and whether rounding should happen at each step or only at the end. Those decisions matter more than changing cell formatting.

A practical troubleshooting workflow

Test the function in a blank cell with a simple numeric value and a clear digit count. If that works, the original data or reference is the likely issue.
Inspect the referenced cell’s contents and format. Convert numbers stored as text, remove unwanted characters, and confirm decimal separators.
Compare the formula result in the formula bar with the displayed value. Adjust the number format only if the value is correct and the display is misleading.
Check Formulas > Calculation Options and recalculate if the result is stale.
Review the rounding rule and the timing of rounding in the wider calculation. Record any required convention so that other users do not mistake display formatting for mathematical rounding.

This sequence keeps troubleshooting focused: establish whether Excel recognizes the input, whether the formula calculates, and whether the final display communicates the result accurately.

Frequently Asked Questions

Why does ROUND not change my number? The value may already be rounded to the requested place, or the cell may show fewer decimals through formatting. Check the formula’s second argument and compare the result in the formula bar with the grid display.

Why does ROUND give #VALUE!? One of the arguments may contain text that Excel cannot interpret as a number. Check for imported text, spaces, symbols, and separators, then convert or clean the input.

Does formatting a cell round the value? No. Number formatting changes the displayed decimal places, not the value used in calculations. Use ROUND in a formula when later calculations must use a rounded result.

How do I round to the nearest 10 or 100? Use a negative number of digits. With 1,276 in A2, =ROUND(A2,-1) returns 1,280, while =ROUND(A2,-2) returns 1,300.

Why is Excel showing my ROUND formula instead of its answer? The cell may be formatted as Text, the entry may have a leading apostrophe, or Show Formulas may be on. Change the cell to General and re-enter the formula, or turn off formula display under the Formulas tab.

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.