Why Does Excel Show ####? | What It Means

You type a value into Excel, hit Enter, and the cell fills with ####. It looks like an error. Most of the time, it isn’t. Excel is telling you the value exists, but the sheet can’t show it in the way that cell is set up right now.

That usually points to one of two things. The column is too narrow for the number, date, or time. Or the cell is using a date or time format and the result lands on a negative value that Excel can’t show in that format.

Once you know that, the fix gets a lot easier. You don’t need to rebuild the file, strip out formulas, or start over. You just need to find which of those two causes is behind the hash marks and fix the sheet at the source.

Why Excel shows #### in the first place

Excel stores a real value in the cell, then applies formatting so that value looks like a date, time, currency amount, percentage, or plain number. When the formatted result won’t fit, Excel swaps the visible value for hash marks. The data is still there.

The most common trigger is width. A date like 4/2/26 may fit in a narrow column, while Thursday, April 2, 2026 won’t. The same thing happens with large currency values, long account numbers, and times with seconds.

The other trigger is a date or time result that drops below zero. That tends to happen when a formula subtracts one time from another and the answer is negative, or when a date calculation lands before Excel’s display rules can show it in the selected format.

What #### does not mean

It does not usually mean the workbook is corrupted. It also does not mean the formula failed in the same way as #VALUE!, #DIV/0!, or #NAME?. Those are formula errors. #### is a display issue most of the time.

• If the formula bar shows a normal value, the data still exists.
• If widening the column fixes it, the sheet is fine.
• If only date or time cells show ####, formatting is the first place to check.

Why Does Excel Show ####? Common cases you’ll run into

The pattern often gives the answer away. If a whole date column turns into #### after you switch formats, the column width is the likely cause. If one subtraction formula does it while nearby cells look normal, the formula may be returning a negative time or date result.

Columns that are simply too narrow

This is the case most people hit first. Excel is trying to show the full value, but the visible space is smaller than the formatted result. That can happen after you paste data, change fonts, apply a new number format, or shrink a column by accident.

Microsoft’s page on how to correct a ##### error points to narrow columns as the main cause. That same article also notes that negative dates and times can trigger the same display.

Dates that became longer after formatting

A cell that once showed 4/2/26 may switch to #### after you apply a long date format. Excel did not lose the date. The display just got longer. A custom format with month names, day names, or full years can push past the current width right away.

Negative time results

This pops up in timesheets, schedules, and shift logs. Say one formula subtracts end time from start time in the wrong order. The result is negative. Excel may show #### rather than a negative time value in a standard time format.

Negative date results

Date math can do the same thing. A formula that subtracts a later date from an earlier one may return a negative serial result. If the cell is formatted as a date, Excel can show #### instead of a readable value.

How to tell which cause is behind the hash marks

Use a quick check before you change anything. Click the cell and look at the formula bar. If you can read a date, number, or formula result there, the cell still has content. Then try one small change at a time.

1. Widen the column a bit.
2. Change the number format to General.
3. Check whether the formula returns a negative date or time.
4. Look for pasted values stored in a format that no longer fits.

If widening the column clears it, you’re done. If not, switch to General. If the cell then shows a negative number, the formula result is the issue, not the width.

Situation	What’s usually happening	Best first move
Date cell shows #### after a format change	The longer date format no longer fits	AutoFit the column or use a shorter date style
Currency values show #### in one narrow column	The column width is smaller than the formatted amount	Widen the column or cut decimal places
Time subtraction returns ####	The formula result is a negative time	Check formula order and time logic
Date subtraction returns ####	The formula result is a negative date serial	Check which date is earlier and which is later
Only one cell shows #### after paste	The pasted value brought in a wider format	Clear formatting or set the cell to General
Whole column flips to #### after font change	The new font takes more horizontal space	AutoFit the column width
Cells show #### but formula bar shows a value	The data is fine; display settings are blocking it	Check width first, then format
Hash marks appear only in printed view	Print scaling or column compression is squeezing the display	Adjust print scaling or widen columns

Fixes that clear #### fast

Start with the easy one. Put your pointer on the right edge of the column header and double-click. That uses AutoFit and resizes the column to the widest visible value. Microsoft shows that method in its page on changing column width and row height.

Widen the column

If AutoFit makes the sheet too wide, drag the column edge manually until the value appears. This is often the cleanest fix for invoice totals, dates, and IDs that need to stay in their current format.

Use a shorter number or date format

If the sheet is tight and width matters, shorten the display instead. A short date, fewer decimals, or a plain number format can free enough space without changing the underlying value. Microsoft’s page on formatting dates in Excel shows how different date styles change what appears in the cell.

Check formula order in time and date math

If the result is negative, fix the formula logic. In a time sheet, subtract start time from end time, not the other way around. In date math, subtract the earlier date from the later date when you want elapsed days.

If you actually need to flag a negative result, it may help to keep the raw calculation in one helper cell and use a second cell to show a label such as Late or Early. That avoids a wall of #### while still keeping the workbook honest.

Switch to General for a quick test

This is one of the fastest checks in Excel. If you change the cell format to General and the hash marks turn into a negative number, you’ve found the cause. You can then decide whether the formula needs fixing or the sheet needs a different display plan.

Fix	When it works best	Trade-off
AutoFit column	Values are correct and only width is the issue	May make the sheet wider than you want
Shorter date or number format	You need a compact layout	Shows less detail in the cell
Change cell to General	You need to test the real stored result	Cell may lose the display style you want
Fix formula order	Date or time subtraction returns a negative result	Needs a check of workbook logic
Use helper cells	You need cleaner output from tricky formulas	Adds extra cells to the sheet

Sheet habits that stop the problem from coming back

Most #### cases show up in the same kinds of files: schedules, payroll sheets, imports, and templates shared across teams. A few habits cut the mess down fast.

• AutoFit columns after pasting fresh data.
• Use one date style across the sheet instead of mixing short and long formats.
• Check time formulas with one known sample before filling them down.
• Leave breathing room in columns that hold currency, dates, or timestamps.
• Use helper columns when formulas mix raw calculations and reader-facing labels.

Watch imported data

Imported values can arrive with odd formats attached. A cell may hold the right number but carry a display style that no longer fits your layout. When a clean-looking import suddenly shows ####, test a few cells with General before rewriting formulas that were fine all along.

Be careful with print scaling

A sheet that looks fine on screen can break in print view if scaling squeezes columns. If the file is meant for export or print, scan for hash marks there too. This catches layout trouble before someone opens a PDF and thinks the numbers vanished.

When #### points to a bigger workbook issue

Most cases are harmless. A few are worth a closer look. If only one group of formulas returns #### and widening does nothing, check the math. If a template suddenly starts doing it after a structural edit, a reference may have shifted. And if users keep forcing columns narrow to fit a dashboard, the layout may need a rethink.

That’s the real value of understanding this display. #### is Excel’s way of saying, “I have something here, but I can’t show it like this.” Once you treat it as a display clue instead of a disaster, the fix usually takes seconds.