Why Excel Shows #### and How to Fix It

Excel shows #### when a value is valid but can't be displayed in the space the cell has. Most of the time the column is too narrow, so double-click the right edge of the column header to widen it. If widening doesn't help, the cell holds a negative date or time, or its number format produces more characters than the value suggests, such as a long date format or accounting padding. The hashes are a display message, not damage: click the cell and the formula bar still shows the real value, and nothing has been lost.

That last part is worth holding on to, because #### looks like an error and isn't one. The rest of this post is a lookup table that starts from what you see and tells you which cause you have, then the fix that works and the one that only feels like it should.

What is Excel telling you with ####?

It's telling you it would rather show nothing than show something wrong. A number that gets clipped in the middle looks like a different number, and a date that loses its last digits looks like a different date. So Excel replaces the whole display with a row of hash characters and leaves the underlying value alone.

Microsoft's own troubleshooting page names two causes: the column isn't wide enough for the cell contents, or a formula returned a date or time as a negative value. Those two cover most of what you'll meet, and this post adds the cases that come from number formats and long text.

Three quick checks tell you which one you're in:

Click the cell and read the formula bar. If the bar shows a normal number or date, the value is fine and this is a width or format problem. If it shows a formula that subtracts two dates or times, suspect the negative case.
Widen the column a lot. Drag the boundary out far past the point you'd need. If a value appears, it was width. If the hashes stay, it's something else.
Look at the Number group on the Home tab. The box shows the format applied to the cell: General, Number, Date, Time, Text. That's your best clue about the cause.

Why doesn't widening the column always fix it?

Because width is only one of four causes, and the other three ignore it entirely. Here is the lookup. Find the row that matches what's in your cell.

What the cell holds	What you see	The cause	The fix that works	The fix that doesn't
A normal number or date	`####` that clears when you drag the column wider	Column too narrow for the formatted value	Widen the column, or shorten the format	Nothing wrong with the value, so retyping it changes nothing
A formula that subtracts one date or time from a later one	`####` at any width	The result is negative, and a negative date or time can't be shown	Fix the formula so the result is positive, or change the cell to a number format	Widening the column, however far
A very long entry in a cell formatted as Text	`####` in place of the text	Long text in a Text-formatted cell (see the note below)	Set the cell to General, then re-enter the value	Widening, unless the text genuinely needs it
A number with a long custom format	`####` even though the value is short	The format adds characters: currency symbol, padding, spelled-out month and weekday	Shorten the format, or widen to the formatted length	Decreasing the font size on one cell, which breaks consistency
A big number in a narrow General column	A rounded number or `1E+11`, not hashes	General shortens itself to fit	Widen if you need the digits	Treating it as a hashes problem

The last row is a useful contrast. The General format is forgiving. Microsoft's number format reference says General rounds numbers with decimals when the cell isn't wide enough, and switches to scientific notation for large numbers of 12 or more digits. So General makes numbers shrink to fit. Hashes come from formats that have committed to a fixed layout: dates, times, currency, accounting. If a column of dates and currency amounts is full of hashes while the plain numbers next to it just look rounded, that is the explanation.

Why do negative dates and times show hashes?

Excel stores a date as a serial number counting days from a starting point. Microsoft's date systems reference explains that in the 1900 date system, which is the default in Excel for Windows and in Excel 2016 for Mac and later, the count starts at January 1, 1900. A negative result would land before the start of the calendar, so there is no date to show. Times behave the same way: the result of subtracting a later time from an earlier one is negative, and it can't be drawn as a clock time.

You usually meet this in a formula like =B2-A2 on two times, where B2 is the earlier one. Overnight shifts and timesheets trigger it constantly: clock in at 10:00 PM, clock out at 6:00 AM, and the subtraction goes negative.

What works:

Make the subtraction come out positive. Put the later time first. For a shift that crosses midnight, the standard pattern is =MOD(B2-A2,1), which wraps a negative result around to the positive time across midnight. That's a general Excel technique rather than something specific to this error, and it fits the clock-in, clock-out case.
Change the result cell to a number format. If the negative value is meaningful, such as "we're 3 days early", format the cell as Number so the minus sign can appear. Microsoft's page lists this too: change negative formula results that are formatted as dates or times to a different number format.
Check what you're subtracting. If one of the "dates" is actually text, the result can be nonsense. That's a different problem with its own fix in Fix inconsistent dates in Excel.

What doesn't work: widening the column. You can drag it across the screen and the hashes stay, because the width was never the issue. This is the single case where "widen it" is a pure waste of time, and it's the quickest test of your cause. Widen a lot, and if nothing changes, go looking at the formula.

Why does a long text entry turn into ####?

This is the odd one, and I'm going to be careful with it. A widely repeated report says Excel shows hashes for a text entry over about 255 characters when the cell is formatted as Text. I can't confirm the exact threshold against Microsoft's documentation, and current Excel versions may behave differently from the older ones where it was first reported. What Microsoft does document is that a cell can hold up to 32,767 characters, per its Excel specifications and limits, so the text itself is fine. The trouble is only in the display.

So treat it as a symptom pattern rather than a rule. If a cell holds a long passage, its format is Text, and it shows hashes at any width, the practical fix is the same whatever the exact threshold:

Select the cell and set its number format to General on the Home tab.
Re-enter the value. A cell formatted as Text stays Text until the content is entered again, so changing the format alone doesn't convert what's already there. Click into the cell and press Enter, or retype it.
If the passage is a paragraph rather than a value, set wrap text on and give the row room, because a paragraph in a single line is a bad reading experience anyway. The trade-off between wrapping and shrinking is covered in Wrap text vs shrink to fit.

If you can't change the cell format, the fallback is to split the passage across cells. For notes and comments, shorter entries are easier to read in a grid regardless.

Which number formats need more width than the value suggests?

This is the cause people miss, because the value looks short. The cell holds 4 or a date, and it's the format that adds characters. Excel measures the displayed text, not the stored number.

Long dates. A date shown as a weekday, a full month name, the day and a four-digit year needs a lot more room than the same date as 09/30/2026. Microsoft's advice for this case is to change to Short Date. Month names are the worst offenders: "September" is nine characters before you've added anything else.
Accounting and currency. These formats add a currency symbol, thousands separators, parentheses or a minus sign and, in accounting, padding so the symbol lines up at the left edge. A value of 1250 that displays as $ 1,250.00 needs more than five characters of width. The grammar behind these is laid out in the number formatting guide, so I won't repeat it here.
Fixed decimals. A format with four decimal places turns 3 into 3.0000. Microsoft's suggestion is to use Decrease Decimal when numbers have too many decimal places.
Larger font or bold. A bigger font widens the same characters. If one cell in a column has a larger font than its neighbours, that cell can show hashes while the rest are fine.

The practical rule: size a column for the longest thing its format can produce, not for the value you have today. A date column should be as wide as the widest month name, and a currency column as wide as the biggest amount you expect plus the symbol and separators. That is a decision you make once, not something you re-fix every month.

How do you size columns so it doesn't come back next month?

The usual fix is AutoFit, and for a one-off file it's fine. Double-click the boundary and the column grows to show the widest cell. The problem shows up when the sheet is reused. Next month's data has a larger figure or a later month name, the column is now too narrow, and the hashes return the day someone else opens the file.

Two habits stop that:

Set widths for columns that grow. A revenue column, a date column and a running total are all going to see values wider than today's. Give them a deliberate width with headroom, using Home > Format > Column Width, rather than the exact fit AutoFit produces. Exact fit is the width that will fail first. The measured starting widths for dates, currency, codes and names are in Excel column widths and row heights.
Fit the number, not the column, when space is tight. The Format Cells dialog has a Shrink to fit option under Alignment, which Microsoft lists as a fix. It's useful in a pinch, but text at different sizes down a column looks uneven, so use it for one stubborn cell rather than a whole column.

You can also make the format shorter. Change a long date to a short one, drop the decimals on a summary figure, or scale thousands so a figure prints as 1,250 rather than 1,250,000. Fewer characters need less width, and a shorter number is usually easier to read anyway.

If you'd rather not size every column by hand, the Excel formatter does it as part of its plan. It measures each column's header and its longest value, adds padding, and sets widths that fit, with a minimum so short columns don't collapse, so the width-caused hashes are gone when you download the file. It doesn't touch your formulas, so if a negative time is the cause, the fix is still in the formula itself. Drop an .xlsx or .csv on it and compare. Nothing is uploaded, and the free tier is complete.

Frequently asked questions

Is #### an error in Excel?

No. It's a display message. Unlike #DIV/0! or #REF!, it doesn't mean a formula failed. It means the value doesn't fit the cell as formatted, and the value itself is intact. Click the cell and check the formula bar, and you'll see the real number or date. The one exception is a negative date or time, where the value is a legitimate result but can't be shown in a date or time format.

Why does my date show as ####?

Two possible reasons. Either the column is too narrow for the date format, which is common with long formats that spell out the weekday and month, or the date is negative because a formula subtracted a later date from an earlier one. Widen the column first. If nothing appears, look at the formula, and if it subtracts dates, put the later date first.

How do I fix #### without widening the column?

Make the content shorter. Change the number format to something narrower, such as Short Date for a date, fewer decimals for a number, or a shorter custom format. You can also use Shrink to fit in the Alignment settings of Format Cells. Both are on Microsoft's list of alternatives to widening; a smaller font works too. None of them help with a negative date or time, which needs the formula or the format changed.

Does Google Sheets show #### too?

The fixes carry over even if the display doesn't match Excel one for one. In Sheets you resize a column by right-clicking its letter and choosing Resize column, or by dragging the boundary, and the shorter-format advice applies in the same way. This post is about Excel, and I haven't checked every case in Sheets, so if a cell looks clipped there, widen it and check the value in the formula bar as the first step. For how the two apps differ on formatting more broadly, see Excel vs Google Sheets formatting.