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.

 

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.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.