Sometimes, you may type a formula into Excel, and when you press return, your cell simply shows #####, instead of a meaningful value.
This problem most commonly occurs because the cell is not wide enough to display the value that it has calculated.
SolutionThis problem is easily solved, by altering the cell width. The easiest way to do this is to drag the bar (shown in the image on the right) until the cell is wider
If Excel continues to display a string of # symbols, no matter how wide you make your column, it is likely that Excel is attempting to display the contents of the cell as a date or time, but the cell contains a negative value.
As dates and times are stored as positive numeric values within Excel, a negative value is an invalid date or time. Excel shows this by filling the cell with # symbols.
If the cell is meant to contain a date or time, check your formulas - you should not have a negative date or time.
If the cell is not meant to contain a date or time, change the formatting of the cell.
To change the cell formatting :