Excel 0 not showing

If Excel 0 is not showing, first check whether the cell contains a true zero, a custom format is hiding zeros, or text imported with a leading zero; fix the cause, not the value. Leaving it alone can break totals, hide missing data, and turn IDs into the wrong numbers. This guide gives a fast check path for formulas, formatting, charts, and imported data so you can restore zeros without breaking calculations.

What zero hiding means in Excel

The same symptom can mean two different things. A cell can contain the number 0 and appear blank, or it can contain text such as 0123, where the leading zero disappears because Excel treats the entry as a number. Check the value first, then change the format or formula.

Check what the cell stores

Click the cell and look at the formula bar. If the bar shows 0, the value is there and a display rule is hiding it. If the bar shows 123 after you type 0123, Excel treated it as a number. If the bar shows a formula such as =IF(A1=0,"",A1), the blank is coming from the formula.

Say your warehouse sheet shows 00417 in a product column on one sheet and 417 on another. That points to formatting or entry rules, not a broken formula. Suppose a sales total cell displays nothing after a return value of zero. That usually points to a zero-hiding setting or a formula that returns blank on purpose.

Likely causes, from most to least

Most cases come from display settings, cell formats, or formulas that intentionally replace zero with blank. Less often, conditional formatting, CSV import choices, or chart settings hide the value after it reaches the sheet. Use the cause that matches the symptom before you change anything else.

Worksheet zero-value display setting

Excel can hide all zero values across your entire worksheet. That setting affects cells only, not the stored value, so formulas and totals can still work while the grid looks blank.

1. Open File > Options > Advanced on Windows.
2. In Display options for this worksheet, check Show a zero in cells that have zero value.
3. On Mac, go to Excel > Preferences > View > Zero values.
4. If only one worksheet is affected, switch sheets and confirm the setting for each sheet name.
5. If the file came from a template, check the template sheet before copying it again.

Cell format is hiding or stripping zeros

General number format strips leading zeros from numeric entries, so 0123 becomes 123. A custom number format can also hide zero values, including a pattern like 0;-0;;@.

1. Select the affected cells.
2. Open Home > Number Format and check the current format.
3. Choose General for normal numeric display, or Text for ZIP codes, phone numbers, and IDs.
4. For fixed-length codes, use Custom and enter 00000 for five digits.
5. If a custom format uses semicolons, remove the pattern that hides zero values.

Formula logic returns blank or dash

An IF formula pattern can replace zero with blank or a dash on purpose. That is useful for reports, but it can also hide a value you need to audit.

1. Click the cell and read the formula bar.
2. Look for formulas such as =IF(A1=0,"",A1) or =IF(A1=0,"-",A1).
3. Edit the formula so zero returns 0 instead of "" if you need the value to appear.
4. Fill the edited formula down the column if the same logic applies elsewhere.
5. If a summary sheet relies on blanks, review the downstream totals before changing every formula.

Conditional formatting or import rules hide what you see

Conditional formatting can make zeros invisible by matching the font color to the background. Imported data from a CSV file can also cause Excel to remove zeros during auto-detection.

1. Go to Home > Conditional Formatting > Manage Rules.
2. Check whether any rule targets zero values or sets the font color to match the fill.
3. Delete the rule or edit its format so the zero is visible again.
4. For CSV data, re-import through Data > From Text/CSV and set the affected column to Text.
5. If the import already happened, re-open the source file and paste values after formatting the destination column as Text.

Why is my 0 not showing in Excel?

The fastest check is the worksheet zero-value display option, because it can hide every zero in the active sheet at once. If that setting is already on, the next place to look is the cell format. After that, inspect the formula bar for IF logic that returns blank instead of 0.

How do you restore zero values?

Turn on zero-value display, remove any custom format that suppresses zeros, and confirm the formula returns a numeric zero instead of an empty string. If the sheet came from another person or template, check whether the same rule exists on copied sheets as well.

1. Open File > Options > Advanced.
2. Under display options for the worksheet, enable Show a zero in cells that have zero value.
3. Change the cell format to General if the value should be numeric.
4. Delete any custom number format such as 0;-0;;@ that hides zero values.
5. Replace formula blanks with 0 where the report must show zero.

How do you keep leading zeros in Excel?

Use Text format for ZIP codes, phone numbers, product IDs, and other fixed strings that must keep their leading zeros. For a one-off entry, a leading apostrophe tells Excel to treat a number as text. For a fixed length, a custom format such as 00000 pads the value to five digits.

Text format and apostrophe prefix

A leading apostrophe tells Excel to treat a number as text, and the apostrophe does not appear in the cell display. This is useful for quick single entries. Do not add spaces in front of numbers; spaces create a different value and can break lookups.

1. Select the destination cells.
2. Set the format to Text before typing or pasting.
3. For one-off entries, type an apostrophe first, then the value, such as '0123.
4. Press Enter and confirm the leading zero remains visible.
5. Use Text only when the number is an identifier, not a quantity.

Custom format for fixed-length codes

Use a custom number format when the value is numeric but must always display the same length. A pattern like 00000 displays five-digit values with leading zeros while keeping the number usable in calculations.

1. Select the cells that should always display the same length.
2. Open Ctrl+1 and choose Number > Custom.
3. Enter a pattern such as 00000.
4. Confirm the displayed value now matches the required length.
5. Use this only when fixed-width display matters, such as internal codes.

Formulas, imports, and charts

These cases usually come after the cell already contains the right value. If a formula returns blank, the fix belongs in the formula. If a CSV stripped zeros, the fix belongs in the import step. If a chart hides zero, the fix belongs in the series or label settings.

CSV and imported data

Excel can remove zeros during CSV import when it auto-guesses a column as numeric. That is common with postal codes, product IDs, and account numbers.

1. Re-open the source file using Data > From Text/CSV.
2. Change the affected column type to Text before loading the data.
3. If the file is already loaded, format the destination column as Text first.
4. Reload the file or paste the source data again.
5. Check a sample row such as 01234 to confirm the leading zero remains.

Charts and labels

Excel can hide zeros in charts if the chart is set to ignore zeros in the series. That can make a data label, axis, or plotted point vanish even when the worksheet cell still shows 0.

1. Select the chart.
2. Open Chart Design > Select Data.
3. Check whether the series excludes zero values or points to blank cells.
4. Review Format Data Labels and confirm zero is allowed to display.
5. If needed, change the source range so the chart reads the real zero cells.

How to keep the problem from coming back

Set the entry format before you type or paste data. Use Text for identifiers, General for quantities, and a custom pattern only when the number needs fixed-width display. For shared templates, audit copied sheets for hidden-zero rules so one worksheet does not behave differently from the rest.

• Format ZIP codes, phone numbers, and IDs as Text before entry.
• Use 00000 or another fixed-length format only when the value must stay numeric.
• Check CSV import settings instead of pasting raw source data into a numeric column.
• Review shared templates for zero-hiding custom formats and worksheet display settings.
• Flag any IF formula that returns blank, dash, or empty text for a zero result.

Excel 0 not showing diagnostic table

Use this table to match the symptom to the fix without changing the wrong thing first.

Frequently asked questions

Why does Excel not show 0 in a cell?

The cell may contain 0, but the worksheet display setting, a custom number format, or conditional formatting is hiding it. Open Format Cells first, then review Home > Conditional Formatting > Manage Rules if the number is still invisible.

How do I make Excel show zero values again?

Turn on Show a zero in cells that have zero value, remove any custom format that suppresses zero, and replace blank-returning formulas with a numeric zero. If the workbook came from a template, repeat the same check on every copied sheet.

Why does Excel remove zeros from ZIP codes and product IDs?

Excel treats entries like 0123 as 123 when the cell uses General format. Use Text format for those identifiers, or re-import the CSV with the column set to Text before Excel guesses the type.

How do I show 0 in Excel charts?

Check the chart series and labels through Chart Design > Select Data, then verify that the source range contains real zero cells. If the chart ignores zeros, change the series setup so the zero value is included instead of skipped.