Why Excel Shows ##### in a Cell

When Excel is showing hashtags (#####) in a cell, it's telling you the value doesn't fit. Usually the column is too narrow for the number or date in its current format, and widening the column fixes it in one double-click. If the hashes stay no matter how wide the column is, the cell holds a negative date or time, and the formula needs a fix.

What do the ##### symbols mean in Excel?#

is a display problem, not an error. The cell's value is still there, and any formula that uses it still gets the

right number. Click the cell and the formula bar shows the real value.

Excel uses hashes because it refuses to show a number that's cut off. Showing 1,25 of 1,250,000 would be misleading, so it shows ##### until the whole number fits. In the General format, Excel first tries rounding the decimals to make a number fit; once it can't shorten it any further, or when the cell has a fixed format such as currency, comma style or a date, you see hashes.

Text behaves differently: long text spills into the empty cells to its right, or is cut off at the edge if the next cell has something in it. Numbers and dates never spill over, which is why only they turn into hashes.

Fix 1: widen the column (AutoFit)#

The quickest fix is to let Excel size the column to fit its contents.

1. Move the mouse to the column header row, onto the right edge of the column's letter (between C and D, for column C). The pointer becomes a double arrow.
2. Double-click. The column resizes to fit its widest value.

This works the same on Windows and Mac. To fit several columns at once, select their headers first, then double-click any of the edges.

From the ribbon, use Home > Format > AutoFit Column Width. On Windows, the ribbon keys are Alt, H, O, I. You can also drag the edge to any width you like, or set an exact width with Home > Format > Column Width.

Fix 2: make the value shorter instead#

Sometimes you can't widen the column, for example in a printed report with a fixed layout. Make the value take less space instead:

• Use a shorter number format. 1,250,000.00 needs more room than 1,250,000. Remove decimals with Decrease Decimal on the Home tab. A long date like Wednesday, October 30, 2026 fits better as 10/30/2026. Our guide to formatting numbers, currency, percent and dates shows the options.
• Shrink to fit. Press Ctrl+1 (⌘1 on a Mac) to open Format Cells, go to Alignment and tick Shrink to fit. Excel reduces the font size until the value fits.
• Use a smaller font for the whole column.

A date format on a number#

If a cell that should show a small number like 14 shows hashes or a strange date, it may have a date format by mistake. Reset it to the General format with Ctrl+Shift+~ on Windows or Control+Shift+~ on a Mac. The More formatting lesson walks through exactly this fix.

Fix 3: negative dates and times show ##### at any width#

If you widen the column and the hashes stay, the cell holds a negative date or time. Hover over the cell and Excel shows a tip saying that negative or too-large dates and times show as #####.

Why negative? Excel stores dates as numbers: days counted from January 1, 1900. Times are fractions of a day, so 6:00 AM is 0.25. There's no date before day 1, so a negative result can't be shown as a date or time. Our guides to why Excel stores dates as numbers and the how Excel stores dates lesson explain the system.

The two usual causes:

Times that cross midnight#

A night shift from 22:00 to 06:00 is 8 hours, but =C2-B2 gives 0.25 − 0.9167 = −0.6667, which shows as #####.

=MOD(C2-B2,1)

MOD with a divisor of 1 keeps only the fraction of a day and adds a whole day when the result is negative. The answer is 0.3333, which is 8 hours. Format the cell as time (h:mm) to see 8:00, or multiply by 24 to get the number of hours: =MOD(C2-B2,1)*24.

Other things that look like#

A few other displays are easy to confuse with the column-width problem:

• #VALUE!, #REF!, #NAME? and other errors start with # but end with ! or ?. Those are real errors in the formula.
• A formula that shows as text, like =SUM(B2:B9) appearing in the cell, is a different problem: the cell is formatted as Text, or Show Formulas is on. See Excel shows the formula instead of the result.
• Dates that show as numbers like 45663 need a date format, not a wider column. The DATE, YEAR, MONTH and DAY guide covers building and reading dates.

If a total is wrong rather than hidden, look for a formula that includes its own cell; our guide to circular reference warnings shows how to find one.

A quick checklist when you see#

1. Click the cell. Does the formula bar show a sensible value? Then it's only width.
2. Double-click the column edge to AutoFit.
3. Still hashes? It's a negative date or time. Check the order of the subtraction.
4. For times across midnight, use =MOD(end-start,1).
5. Can't widen? Shorten the number format or use Shrink to fit.

Practise it#

Try the night-shift exercise on this page. Then use the More formatting lesson to practise number and date formats, and the DATE, YEAR, MONTH and DAY lesson to see how Excel turns dates into numbers.