rozkmina/iStock/GettyImages

When a cell in Excel displays a series of hash marks (#####), it indicates that the column is too narrow to show the cell’s content. This can happen when you paste a large number, the column width is manually reduced, or the cell is formatted in a way that conflicts with the value.

Why the # Symbols Appear

Excel will show ##### when the cell contains a number that cannot fit in the available space. It also shows them if a formula produces a negative number in a column formatted for dates, or if the cell is set to a format that cannot display the entered value.

How to Resolve the Issue

1. Resize the Column Manually
   Move the cursor to the column header’s right edge until it turns into a double‑arrow icon. Click and drag to widen the column until the number appears.
2. Use AutoFit
   Select the affected column(s), go to the Home tab, click Format on the ribbon, and choose AutoFit Column Width. Excel will automatically adjust the width to fit the content.
3. Check Cell Formatting
   Right‑click the cell, select Format Cells, go to the Number tab, and choose an appropriate format (e.g., Number, Currency, or General). Avoid date formats for numeric data.
4. Verify the Stored Value
   Even if the cell shows #####, the actual value remains in the cell. Hover over the cell to view a tooltip, or look at the formula bar for the correct number.

Preventing Future Occurrences

When entering large numbers directly, Excel usually expands the column automatically. The problem often arises when you paste data from another source or reduce the column width afterward. Keep columns wide enough for the expected data or use AutoFit regularly to avoid ##### symbols.