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.
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.
Step 4: Double-click your mouse to expand the column. The cell that previously contained the ###### symbols will now display the correct cell value.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.