Buzz
Various factors can cause Excel to display ##### error, preventing users from determining the accurate value of cells, data columns, and continuing calculations. Below are some reasons and solutions to fix Excel displaying #####.
Causes and Solutions for Excel Displaying #####
Cause 1
This error may occur when the cell is not wide enough to display the calculated value.
Some cell formats (such as decimal format) may be shortened if the cell is not wide enough to display the entire number. However, some formats (such as date and time) require the cell to be wide enough to display the entire value. If the cell is not wide enough, Excel will display #####.
Solution to Fix the Error
To resolve this issue, the simplest way is to change the width of the Excel cell. You can do this by dragging the column headers (as shown below) until the Excel cell is wider.
Alternatively, another way is to double-click on this bar, and Excel will automatically resize to fit the content in the cell.
Cause 2
If Excel continues to display the ##### character string, even though you have expanded the column and Excel cell, it may be trying to display the content of the cell, such as date and time, but the cell contains an invalid date or time value.
Because date and time values in Excel are stored as positive numbers, if there is an invalid date and time value (such as a negative value), Excel will display ##### in the cell.
Solution to Fix the Error
If the Excel cell contains a date and time value, try checking your formula again. Dates and times in Excel must be positive numbers. Note that Excel cannot handle negative date and time values.
If the Excel cell does not contain a date and time value, try changing the date format of the cell to fix the Excel error displaying #####. The quickest way to change the date format of the cell is to select the cell you want to format, then select the cell format from the dropdown menu (the drop-down menu) in the Number group on the Home tab on the Excel Ribbon as shown below:
Above are some reasons as well as methods to fix Excel displaying ##### error. If you encounter this issue, you can refer to the troubleshooting methods provided by Mytour to resolve it. Besides fixing the pound sign display issue, you may also encounter common Excel errors, so quickly learn about common Excel errors and how to fix them for the earliest solution.
