How to correct a ##### error

The ##### error in Excel means the cell is not wide enough to display the data or the data format causes display issues (especially with dates or negative times).

✅ Common Causes & Fixes for ##### Errors

🔹 1. Column Too Narrow

If a number or date doesn’t fit the column width, Excel shows #####.

Fix:

• Double-click the right edge of the column header to auto-fit the column.
• Or drag the column edge to widen it manually.

🔹 2. Negative Time or Date Value

Excel cannot display negative time or dates.

Example:

• Formula result is =A1 - B1 where B1 > A1 and both are dates/times → #####

Fix:

• Change calculation or data to avoid negative times.
• Use formulas to check for negatives and handle them:

  =IF(A1>=B1, A1-B1, "Negative time")
  

🔹 3. Wrong Cell Format

If a cell formatted as Date contains a very large number or text, it may show #####.

Fix:

• Change the cell format to General or Number:
  • Right-click cell > Format Cells > Number tab > General or Number

🔹 4. Very Large Numbers in Narrow Cells

Long numbers (e.g., 15+ digits) can’t display fully in narrow columns.

Fix:

• Widen the column.
• Format the cell to scientific notation if appropriate.

Summary