Besides errors like #VALUE error in Excel, error e+11 in Excel, we have most likely asked what is the #div/0 error in Excel, what is the #name error in Excel and What is the #### error in Excel?? Below article, GhienCongListen will reveal to you what error #### in Excel is? And how to fix it effectively.
What is #### error in Excel?
Advertisement
The #### error in Excel is a common error because the characters contained in a cell are too long or because the cell containing the data is so small that the display space does not show all the characters in it.
Or another rare case when you get #### error in Excel again is that the date and time are formatted as negative values, so the value cell returns this error.
Advertisement
How to fix #### error in Excel
Based on 2 main causes of #### error in Excel above. We can follow the following 2 ways to fix this problem.
Change the width of the value cell again
Advertisement
To make a column wider to show the contents of the cell, double-click the right edge of the column header, or drag it to the width you want.
Or you can do the following:
- To make the contents display just the size of the cell in Excel, click Page Setup > press the button Align in the dialog box that appears, then select the check box Shrink to fit in the Format Cells dialog box.
Fix date or time as negative value
To fix the date or time is a negative value, you need to do the following:
- When you use the 1900 date system, it is necessary to confirm that the date and time are positive values.
- Use the exact time addition or subtraction formula, avoiding negative results.
- Fix negative formula results that are being formatted as a date or time to a different number format.
See more:
Above, we have just found a clearer answer about what #### in Excel is as well as some quick ways to fix this error. Don’t forget to share the article to let your friends know and regularly follow GhienCongList to update many useful information.
Source: What is #### error in Excel? Simple causes and solutions
– TechtipsnReview