Meaning of #### in Excel

#### in Excel means, the cell is not wide enough to display all the content in a it. Series of hashtags sometimes indicate a time and date formatted cell contains a negative value.

In this topic:

  1. Why am I getting ### in Excel?
  2. How to fix#### Error?

Possible Reasons of Showing #### error in Excel

You will see a #### in Excel sheet when a cell is too narrow to fit the entire content in a cell. Here are the list of reasons that a cell displaying #### error.

  • Entering a large information in a single Cell and it is not wide enough  to fit the content
  • You have copy the data from other file and pasted in a sheet and a column is too narrow to display the cell contents
  • You have enter a negative value and the Cell is formatted as Date or Time
  • Formula in a cell resolving to the negative number and the Cell is formatted as Date or Time

How to fix #### error in Excel

in Excel is not really an error in most cases. You can simply increase the column width so that the content fits in the cells. Here are the list of solutions to fix the #### issue in Excel.

  • Increase the column width and make the column wide enough to fit the content in the Cells
  • Double click on the Column to auto fit
  • Shrink the Cells to fit the information
  • Merge the cells to show the all content of the Cell
  • Make sure that you have not entering negative values if Range of cells formatted as Date/Time
  • Handle the formulas for possible negative values when the format is Date and Time

Share This Story, Choose Your Platform!

Leave A Comment

Excelx.com is a Excel Blog by PNRao to provide latest tips of Excel and help you to Quickly Learn and up-to date with Excel Concepts. We help you to know – how to do things in Excel with Clean and Easy Excel Tips, Shortcuts, Reference, Tutorials and New and Quick Tricks and Methods.

We Provide Free Online Tutorials, Formulas, Templates, Dashboards and Macros to excel in Microsoft Excel. We cover basic to advanced concepts and share creative ideas, Excel tips and Shortcuts with Related Example Files. You Can refer verity of examples covered on latest tools and techniques in Microsoft Excel Applications.

Related Posts