Fix the ##### error

What ##### means

Excel fills a cell with hash marks (####) when the column is too narrow to display the formatted value — most commonly a date, currency, or large number. No data is lost; the value is intact. Widening the column or reducing the number format makes the value visible again.

Common causes

• The column width is smaller than the width required to display the formatted number or date, which is the most common cause.
• A Date-formatted cell contains a negative date serial number (a date before January 1, 1900 in Excel), which Excel cannot display and shows as ####.
• The zoom level is very low (e.g., 25%) and the column appears narrower than it actually is — zooming in may reveal the value.
• A custom number format with many characters (e.g., full month name + year) requires more space than the column provides.
• The column was manually narrowed, or columns were added to a template that collapsed existing column widths.

Example fix

If the column is too narrow to show the full date format, wrapping in TEXT() with a compact format string produces a shorter string that fits. Widening the column and keeping the date format is usually preferable for downstream date math.

How to fix it

1. 1Double-click the column border in the column header to auto-fit the column to the widest value. Alternatively, right-click the column header > Column Width > type a larger number.
2. 2Select the entire column (click the column letter), then in Excel: Home > Format > AutoFit Column Width.
3. 3To auto-fit all columns at once: press Ctrl+A to select all, then double-click any column border between two column headers.
4. 4If the cell contains a date, verify the serial number is positive (check the underlying value with =A2+0 in a General-formatted cell). A negative value means the date formula produced an invalid result.
5. 5If widening the column is not possible (e.g., fixed-width print layout), apply a shorter format: Ctrl+1 > Number > Date > choose a short date format like 'M/D/YY'.

Frequently asked