When a number cell in your worksheet shows as ###, it means the value is there but cannot be displayed in the current column width or format.

What ### Usually Means

  • The column is too narrow to show the full number. The value still exists in the cell; it’s just not visible.
  • This is especially common with:
    • Large numbers.
    • Dates or times that need more space to display.

How to Fix It

  1. Widen the column
    • Move your mouse to the right edge of the column header (e.g., between B and C).
    • When the cursor changes to a double-sided arrow, double-click to auto-fit, or click and drag to make it wider.
  2. Reduce the number/date size
    • Decrease decimal places for numbers.
    • Switch to a shorter date format if it’s a date.

Once you adjust the column or format, the actual value will replace the ### in the cell.