The # # # # # error value indicates that the column is too narrow to display the contents of this cell.
Sometimes Excel can't calculate a formula because the formula contains an error. If that happens, you'll see an error value instead of a result in a cell. Here are three common error values:
# # # # # The column is not wide enough to display the contents of this cell. Increase column width, shrink the contents to fit the column, or apply a different number format.
#REF! A cell reference is not valid. Cells may have been deleted or pasted over.
#NAME? You may have misspelled a function name or used a name that Excel does not recognize. You should know that cells with error values such as #NAME? may display a color triangle. If you click the cell, an error button appears to give you some error correction options. How to use that button is not covered in this course.