Excel Cell Showing 0 Instead of Result? Fix It

Errors & fixes · Updated November 19, 2026

If an Excel cell shows 0 instead of the result you expect, first select it and check the formula bar: this reveals whether the formula actually returns zero or the cell only displays a rounded or incorrectly formatted value. Then check the formula’s references and inputs, confirm calculation is set to Automatic, and inspect the number format.

Why Excel may show zero

A displayed zero can have several different causes, and the right fix depends on which one applies. The cell might contain a formula whose real answer is zero, a tiny decimal that rounds to zero on screen, or a value affected by a formatting choice. Alternatively, the formula may be using unexpected cells, or Excel may not have recalculated it yet.

Start by selecting the cell and looking at the formula bar above the worksheet. If the bar shows a formula such as =A2-B2, inspect its references and inputs. If the formula bar shows a nonzero number while the grid displays 0, suspect number formatting or rounding. If the formula bar shows 0, Excel is calculating or storing zero; formatting alone is not the explanation.

It also helps to distinguish a true zero from a blank cell. A formula can return an empty string, and a custom number format can hide zero values. Those situations may make a cell look empty, rather than show a visible 0. If you can see a zero, check the formula bar and format before changing the formula.

Check whether the formula really returns zero

Click the result cell and read the formula carefully. Confirm that every cell reference points to the intended row, column, and sheet. A formula copied down a column can shift its references; a relative reference such as A2 becomes A3 when copied one row down. If a reference should stay fixed, it may need dollar signs, as in $A$2.

For a basic subtraction example, with the starting amount in A2 and the amount subtracted in B2, =A2-B2 returns 0 when both cells contain 125. That is a correct result, even if you expected a different answer. Check the source values, not just the formula text: the cells may contain values you did not expect, or the formula may point to a different row than the one you are reviewing.

To inspect a formula in stages, select the cell and use Formulas > Evaluate Formula. In the dialog, choose Evaluate to see how Excel resolves each part. This is useful with nested calculations and references, but it does not replace checking whether the underlying data is correct. You can also select a referenced cell from the formula bar or use the Name Box to jump to a cell address.

  • Check for a wrong row, column, sheet name, or range endpoint.
  • Look for absolute and relative references that changed when a formula was copied.
  • Verify that the source cells contain the expected values, not merely the expected appearance.
  • Review conditions in IF formulas and criteria in functions such as SUMIF or COUNTIF.

Increase the displayed decimal places

Excel can store more decimal places than it displays. A small nonzero result may therefore look like 0 when the cell is formatted to show no decimal places. For example, a stored value of 0.004 appears as 0 with a zero-decimal number format, even though the underlying value is not zero.

Select the cell and choose Home > Increase Decimal to show additional places. You can also press Ctrl+1 on Windows to open Format Cells, choose the Number category, and increase Decimal places. On a Mac, Command+1 opens Format Cells. The Mac ribbon also has the decimal-place controls on the Home tab, though their position can vary with the window size.

Formatting changes what you see, not necessarily what is stored or used in calculations. If increasing the displayed decimal places reveals a small value, decide whether that precision is meaningful for your task. Avoid changing the formula just to make a rounded display look different. For instance, adding a ROUND function changes the calculated value; increasing decimal places only changes its presentation.

If a result should be rounded by design, with the value to round in A2 and two decimal places required, =ROUND(A2,2) returns the value rounded to two decimal places. If A2 contains 0.004, the result is 0.00, which may still display as 0 depending on the cell format. Rounding is a calculation choice, so use it only when that precision is appropriate.

Review the cell’s number format

A number format can make a valid result appear misleading. Select the cell and check the Number Format list on the Home tab. Try General or Number to see whether the display changes. A format copied from another cell may show too few decimal places, apply a currency symbol, or use a date or percentage presentation that does not match the value.

Custom formats can also treat positive numbers, negative numbers, zero, and text differently. In a custom format, semicolon-separated sections can specify how different kinds of values appear. A format designed to hide zeros can make zero appear blank, while a format with a literal character could make a value look unlike a standard number. To inspect it, press Ctrl+1 on Windows, choose Number, and look at the Type field under Custom. On Mac, use Command+1 to open the formatting dialog.

Changing a format is a useful diagnostic, but it may not fix the underlying issue. If General still displays 0 and the formula bar also shows 0, the cell is probably calculating zero. If the formula bar shows another value but the grid shows zero, formatting is more likely. Be cautious when changing formats on dates, times, or percentages: the same stored number can look very different under different formats.

Make sure Excel recalculates the workbook

Excel normally recalculates formulas automatically when their inputs change. If the workbook is set to manual calculation, a result can remain at an old value until recalculation occurs. In Excel for Microsoft 365 on Windows, choose Formulas > Calculation Options > Automatic. Then press F9 to recalculate open workbooks, or Shift+F9 to recalculate the active worksheet.

Calculation mode can affect more than one formula, and workbooks opened in the same Excel session may use the current calculation setting. If a formula updates after you switch to Automatic or press F9, that points to a recalculation issue rather than a bad number format. If it remains zero, return to the formula and inputs.

On Mac, check the calculation setting on the Formulas tab if it is available in your Excel build; menu and ribbon layouts can differ by version. Excel for the web generally recalculates supported formulas as workbook values change, but a workbook with external connections or unsupported features may need to be opened in the desktop app for a full diagnosis. Do not assume that pressing Calculate will correct a mistaken formula reference.

Check input data and formula logic

Formulas can return zero because their inputs are blank, stored as text, or excluded by a condition. A cell that looks numeric may actually contain text, particularly after data is imported from a website or another system. Text values can behave differently in arithmetic and criteria-based functions. Check alignment and the formula bar, and try selecting a source cell to see whether Excel recognizes the content as a number.

For a simple total, with numeric entries in B2 through B6, =SUM(B2:B6) adds those values. If the apparent numbers are stored as text, SUM may not include them as expected. One way to investigate is to test a source cell with a function or convert the imported data using Data > Text to Columns, reviewing the preview and settings before completing the conversion. The best conversion method depends on how the source text is structured, especially when decimal and thousands separators vary by locale.

Conditional formulas need their conditions checked as well. An IF formula may deliberately return zero when its test is false, and SUMIF may total nothing if its criteria do not match the source values. Look for extra spaces, inconsistent spellings, date values with time components, or criteria referring to the wrong cell. A formula can be syntactically valid and still answer a different question from the one you intended.

Also inspect formulas that use IFERROR. It can replace an error with a chosen value, including zero, which may conceal the original problem. If the formula is expected to show an error while you troubleshoot, temporarily remove or adjust the error handling in a copy of the formula. Do not replace errors with zero automatically unless zero is a meaningful result for the worksheet.

Use a quick troubleshooting sequence

Work from the quickest checks toward more involved ones. Make a copy of important data before changing formulas or imported values. Then follow this sequence:

  1. Select the cell and compare the formula bar with the displayed value.
  2. Set the cell temporarily to General or Number and increase decimal places.
  3. Check formula references, source values, criteria, and any IF or IFERROR logic.
  4. Confirm that calculation is Automatic, then recalculate with F9 if needed.
  5. Test the formula in a spare cell or use Formulas > Evaluate Formula to isolate the part returning zero.

Testing in a spare cell helps separate formula logic from the original cell’s formatting. With inputs in A2 and B2, =A2-B2 lets you compare a simple calculation against the result you are investigating. If the spare cell returns the expected value but the original does not, compare their formulas, references, and number formats. Avoid overwriting a working result until you understand which difference matters.

When zero is the correct result

Sometimes zero is not an error. A subtraction may balance to zero, a count may find no matching records, or a percentage calculation may have a zero numerator. A small floating-point difference can also occur in decimal arithmetic because computers represent many decimal fractions approximately. In those cases, a displayed value may be extremely close to zero rather than mathematically exact zero.

If the result is meant to be treated as zero within a chosen tolerance, the formula can reflect that rule, but the tolerance should match the task. For example, with a calculated value in A2 and a tolerance of 0.000001, =IF(ABS(A2)<0.000001,0,A2) returns zero when the absolute value is less than that threshold and otherwise returns A2. This is not a universal correction: an inappropriate tolerance can erase a small difference that matters. In HTML, the less-than symbol is written as &lt; so the formula remains valid when copied from the rendered article.

Do not confuse a displayed zero with #### in a cell. Hash marks usually mean the column is too narrow to display a value or a date/time result, rather than that the formula returned zero. Widen the column or adjust the format to investigate that separate display issue.

Frequently Asked Questions

Why does Excel show 0 when the formula bar shows a decimal?
If the formula bar shows a nonzero decimal but the cell displays 0, the number format may be showing too few decimal places. Increase decimal places from the Home tab or open Format Cells and adjust the Number format.

Why does my formula return 0 even though the source cells are not zero?
Check whether the formula references the cells you expect, whether a condition excludes the data, and whether the source values are numbers rather than text. Use Formulas > Evaluate Formula to see how Excel processes a complicated expression.

Can manual calculation make a cell show 0?
Manual calculation can leave a formula showing an outdated result, including an old zero. Set Formulas > Calculation Options > Automatic in Excel for Microsoft 365 on Windows, then recalculate. If the value remains zero, investigate the formula and its inputs.

How do I show more decimal places in Excel?
Select the cell and choose Home > Increase Decimal, or open Format Cells with Ctrl+1 on Windows or Command+1 on Mac. Increasing displayed decimal places does not change the underlying value.

Why does Excel show a blank instead of zero?
A custom number format may hide zero values, or the formula may return an empty string. Check the formula bar and inspect the cell’s format through Format Cells to tell which is happening.

Related

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.