How to Fix Excel Displaying Hash Symbols (####) Instead of Numbers
Question details
The user needs to resolve an issue where Excel cells display a series of hash symbols (####) instead of the actual calculated numbers or dates.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Entering data or calculating formulas involving numbers, dates, or times.
- Observed behavior
- The cell displays '####' instead of the expected numerical value, even though the underlying formula calculates correctly.
Ensure you haven't accidentally deleted any underlying data. The '####' error usually only indicates a visual display issue, meaning your original numbers and formulas are still intact and calculating properly behind the scenes.
Widen the Column to Fit the Data
The most common reason for hash symbols is that the column is too narrow to display the entire number or date format. Expanding the column width will instantly reveal the data.
Identify the column header (the letter at the top) containing the cell that displays the '####' symbols.
Hover your cursor over the right boundary of the column header until it turns into a double-sided arrow. Double-click the boundary to automatically adjust the width to fit the longest entry in that column.
Alternatively, click and drag the right boundary of the column header to the right until the number or date is fully visible in the cell.

Correct Negative Date or Time Values
Excel cannot display negative dates or times. If you perform a calculation that results in a negative time value, it will show as '####'.
Change the Number Format
If you cannot widen the column due to layout constraints, reducing the number of decimal places or changing the format can help the number fit within the current cell.
Easily Manage Spreadsheets and Formatting with WPS Spreadsheet
WPS Spreadsheet offers an intuitive interface for fixing cell display issues like the '####' error. It is highly compatible with Microsoft Excel formats and provides easy-to-use tools for adjusting columns and formatting cells.
- 1. Open your workbook: Launch WPS Spreadsheet and open the file showing the hash symbol errors.
- 2. AutoFit column width: Double-click the right edge of the column header to instantly adjust the width and reveal the hidden numbers.
- 3. Adjust cell format: Right-click the cell, select 'Format Cells', and modify the number of decimal places or date format to fit the cell perfectly.

Frequently Asked Questions
Can I make the text shrink to fit the cell instead of widening the column?
Yes. Right-click the cell displaying '####' and select 'Format Cells'. Go to the 'Alignment' tab and check the 'Shrink to fit' box. The text will automatically reduce in size to fit within the current column width, eliminating the hash symbols.
Why do I see #### when I type a very long number?
If you type a number longer than 11 digits, it may exceed the cell's default display capacity. To display a full long number (like a credit card or ID number) without converting to scientific notation or '####', change the cell format to 'Text' before typing, or type an apostrophe (') before the number.
Does printing the spreadsheet show #### or the actual numbers?
If the spreadsheet displays '####' on your screen, it will also print exactly as '####' on paper. You must widen the columns or adjust the cell formatting before printing to ensure the actual numbers appear on the printed document.




