Sometimes while working with numbers in excel you might come across the hash symbol ###. It might look as if the number which you entered in the cell has been replaced with hash symbols. For example 124.56 would look like ###.## . And once you hover the mouse over the the hash symbol, it would display the number as a tooltip. And you might be wondering what is going on here?
Well, sometimes when you come across this Issue it is primarily because there is not enough space for that number in the cell.
How can I resolve this?
In order to resolve this one would have to basically expand the column on which the cell is residing. That can be done by simply double clicking on the right bar of the column border.