What is ### error in Excel? how to fix ### error in Excel

The causes of ### error in Excel are many and the way to fix this error is also different, depending on the cause of the error. The following article will guide you to fix ### error in Excel.

1. ### error in Excel due to insufficient space in the cell

When the cell in the Excel table is not wide enough to display the content, it will also display the ### error, for example when entering a date or any content.

The simplest way to fix it is that you just need to extend the length of the cell to display the content.

What is ### error in Excel? how to fix ### error in Excel Picture 1

In addition, you can also adjust the content in the cell to be smaller by going up the Ribbon, in the Alignment group, click the arrow icon .

What is ### error in Excel? how to fix ### error in Excel Picture 2

Now click on the Alignment tab and then tick Shrink to fit and then click OK to save. Immediately the content in the cell automatically shrinks to fit the width of the cell.

What is ### error in Excel? how to fix ### error in Excel Picture 3

2. Fix ### error in Excel due to decimals

In case you enter a decimal with many numbers after the comma, the ### error condition in Excel may also occur. You can manually correct it by reducing the decimal part of the number.

We will use the Excel rounding function to shorten the unit after the decimal point. You see how to round numbers in the article How to round numbers in Excel.

3. How to fix ### error in Excel due to date

When entering dates in Excel, if you leave the long date format, the same error will be displayed ### or when the date or time value is negative.

You click on the cell and then look up at the Number section , we click on the Date format adjustment box and then select the short date display type , if you are leaving the long date format and have ### errors in Excel.

To see more how to format dates in Excel, see the article How to format dates in Excel.

What is ### error in Excel? how to fix ### error in Excel Picture 4

In case you enter a negative date and time, Excel will not recognize this data cell and display ###. Now you need to check that you have entered the correct data, use formulas to subtract days or add days to get the correct positive result.

Lesley Montoya

Update 02 June 2021

You should read it

May be interested

Steps to fix Updating Office, please wait a moment (Error 0xc0000142)
when updating office, there is a common error that is 'updating office, please wait a moment'. to fix this error, please follow the steps below.
Steps to lock columns in Excel
locking columns in excel with a password helps you protect columns, prevent others from changing column content or editing columns, affecting all data of the table.
Installation steps to automatically save Excel files to OneDrive
if you are using microsoft 365 version, you can set up the mode to automatically save excel files to your onedrive account.
How to view and restore Excel file versions phiên
with excel we can review the previous working versions of an excel file to review the changes of the document and can restore any version we want.
Steps to restore the default Font in Microsoft Office
to restore the default font that comes with microsoft office, you will need to repair office in the installation.
Steps to cancel automatic numbering in Word
automatic numbering in word helps users do not need to number word lines manually. however, documents do not always need automatic numbering in word