MAPIWhy Does Excel Show ##### Instead of a Number?
A row of hash marks can look like a formula failure, but in many cases the underlying value is still present. Excel is telling you that it cannot display the formatted result in the current cell width, or that a date/time result cannot be represented in the current system.
Excel usually shows ##### when the column is not wide enough to display the full cell contents. It can also appear when a formula returns a negative date or time value. Widen the column first; if the hashes remain, inspect the cell's number format and any date or time calculation.
Key takeaways
- ##### most commonly means the column is too narrow for the formatted cell value.
- A negative date or time result can also display as #####.
- The underlying number may still be correct even though the cell cannot display it.
- Widening the column is the quickest first check before changing formulas.
What it actually means
A ##### display in Excel is a visual indicator that the current cell cannot show its formatted value normally. Microsoft documents column width and negative date/time values as the principal causes.
The main explanation
When a cell contains a valid number or date that needs more horizontal space than the column provides, Excel can replace the visible result with hash marks. This is a display problem rather than proof that the formula itself failed. Microsoft also documents a second case: formulas that produce negative date or time values can show ##### because those values cannot be displayed normally under the 1900 date system. The right diagnosis therefore starts with column width, then moves to the cell's format and any date/time calculation if widening the column does not solve it.
Main causes and reasons
1. The column is too narrow
The formatted number, date, or time needs more horizontal space than the current column provides.
How to recognize it
- Widening the column immediately reveals the value
- Long dates or numbers with many decimals are affected
- The formula bar still shows the underlying value
Why it matters: Microsoft identifies this as the primary reason Excel displays #####.
2. The cell contains a negative date or time result
Certain date or time calculations can produce a negative value that Excel displays as ##### under the 1900 date system.
How to recognize it
- The cell is formatted as Date or Time
- The formula subtracts one date or time from another
- The calculation can produce a negative result
Why it matters: This matters when changing column width does not reveal the value.
3. The number format makes the value wider than necessary
A long date format or many displayed decimal places can make an otherwise valid value too wide for the cell.
How to recognize it
- A shorter number or date format fits
- Decreasing decimal places reveals the value
- Shrink to Fit displays the content
Why it matters: Changing the display format can solve the visual problem without changing the underlying value.
How to identify your situation
The issue was display width, not a broken formula.
Next: Keep the wider column or use a shorter number/date format.
The formula may be producing a negative date or time value.
Next: Check the date/time subtraction and confirm that the result should be positive.
The display format was too wide for the available column.
Next: Use a format that fits the worksheet layout without hiding needed precision.
What you can do
- Widen the column by dragging the right edge of its column header.
- Try AutoFit if you want Excel to size the column to the contents.
- Reduce unnecessary decimal places for long numbers.
- Use a shorter date format when the full date text is too wide.
- Check negative date or time calculations when widening the column does not help.
- Avoid rewriting formulas unless the underlying calculation is actually wrong.
Common misconceptions
The underlying value is often still present; Excel simply cannot display it in the current format or width.
A narrow column is the most common cause, and the formula can still be correct.
Number formatting normally changes how the value appears, not the underlying numeric value itself.
When it may be a bigger problem
If the cell continues to display unexpectedly after width and date/time checks, inspect the formula, cell format, and workbook calculation logic. Complex custom formats or imported data may require additional troubleshooting.
Frequently asked questions
Why does Excel show ##### after I enter a date?
The column may be too narrow for the selected date format. Widen the column or choose a shorter date format first.
Can ##### mean a formula error?
It can be related to a negative date or time calculation, but it is not the same as standard formula errors such as #REF! or #DIV/0!.
Does widening the column change the number?
No. It changes how much room Excel has to display the existing formatted value.
Why do I still see ##### after making the column wider?
If the cell is a date or time, check whether the formula is returning a negative date or time value.
Sources
- How to correct a ##### error — Microsoft SupportOfficial
- Detect formula errors in Excel — Microsoft SupportOfficial
Written by Mapiance Editorial Team
The Mapiance Editorial Team researches, writes, reviews, and maintains practical guides and explainers for MAPIANCE.
Reviewed by Mapiance Editorial Team
Published Sep 4, 2026 · Updated Sep 30, 2026 · Verified Sep 1, 2026