Help with Excel

Richard Buford 0 Reputation points
2026-09-30T19:07:37.96+00:00

I want the ###### to go away that are in my cells

They are covering up numbers

Microsoft 365 and Office | Excel | For home | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-09-30T19:07:51.74+00:00

    ##### usually means the column is too narrow to display the full value.

    Try this:

    1. Find the column that shows #####.
    2. Move the pointer to the right edge of that column header.
    3. Double-click the edge to automatically widen the column.

    Other fixes if needed:

    • Drag the right edge of the column header to make the column wider manually.
    • On Home > Decrease Decimal if the number has too many decimal places.
    • If the cell contains a date, change it to Short Date from Home > Number Format.
    • On Home > Alignment Settings, turn on Shrink to fit to make the contents smaller.

    If the cell is showing a negative date or time value, Excel can also display #####. In that case, change the formula result to a different number format or make sure the date/time result is positive.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.