Why Is Excel Showing ###### Instead of a Number?

An Excel spreadsheet is a convenient way to organize and store data. The grid structure makes it easy to locate a specific bit of data so that you can use it in whatever way you need.

But occasionally the value in a cell might be replaced by a series of ###### symbols and you can’t see the numbers that should be there.

This might at first be troubling, but it is a perfectly normal behavior for Excel 2010 and it is something that you can fix easily.

This is happening because there is more information in the cell than can be displayed with the cell’s current width.

This issue can be resolved by expanding the width of the cell so that it is wide enough to display all of the numbers. So continue reading below to learn how to get rid of those symbols on your spreadsheet and show the numbers instead.

Excel can make it difficult to read data when the cells aren’t big enough to show everything. Our article on how to expand all rows in Excel can show you a quick way to fix that.

Show Numbers Instead of ###### In Excel 2010

We are going to explain how to automatically expand a column width in the tutorial below, which will remove the ###### symbols from your Excel spreadsheet.

However, this method is only going to work for one column at a time. You will need to repeat this process for each column that contains the symbols that you want to replace.

Step 1: Open the spreadsheet in Excel 2010.

Step 2: Locate the ###### symbols that you want to replace with your numerical values.

how to display cell values instead of ###### symbols in Excel 2010

Step 3: Position your cursor on the right border of the column heading at the top of the sheet. Your cursor should be replaced by the symbol in the image below.

position your cursor on the right border of the column heading

Step 4: Double-click your mouse to expand the column. The cell that previously contained the ###### symbols will now display the correct cell value.

an expanded cell column to display cell values

Do you have columns in your Excel spreadsheet that you aren’t using, but you don’t want to delete? Learn how to hide columns in Excel 2010 so that they aren’t taking up space on your screen.

If you are having trouble adjusting your columns so that you can see all the data, then our how to autofit all columns in Excel article can show you how to fix it.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy