Correct a ##### error
This error occurs when a column is not wide enough, or a negative date or time is used.
- Review the following possible causes and solutions.
The column is not wide enough to display the content
Do one or more of the following:
Increase the width of the column
- Select the column by clicking the column header.
- On the
Hometab, in theCellsgroup, clickFormat, point toColumns, and then clickAutoFit Selection.
Tip Alternatively, you can double-click the boundary to the right of the column heading.
Shrink the contents to fit the column
- Select the column.
- On the
Hometab, in theCellsgroup, clickFormat, clickCells, and then click theAlignmenttab.
- Select the
Shrink to fitcheck box.
Apply a different number format
In some cases, you can change the cell's number format to make the number fit within the existing cell width. For example, you can decrease the number of decimal places after the decimal point.
Dates and times are negative numbers
-
If you are using the 1900 date system, dates and times in Microsoft Office Excel must be positive values.
-
When you subtract dates and times, make sure that you build the formula correctly.
-
If the formula is correct but the result is still a negative value, you can display the value by formatting the cell with a format that is not a date or time format.
- On the
Hometab, in theCellsgroup, clickFormat, clickCells, and then click theNumbertab.
- Select a format that is not a date or time format.
- On the