Excel #### appearance 

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s