Properly formatting the data in a spreadsheet can go a long way towards helping your readers understand that data. Supportyourtech.com shows one way that formatting a page for printing can make your data look better. But Excel 2013 also offers a number of different formatting options for numbers, including one that will display your numbers with a percentage symbol after them. But that percentage symbol is not actually a character contained in the cell, so it might be confusing if you are trying to delete it. Our guide below will show you how to remove unwanted percentages from cells in your Excel 2013 spreadsheet by switching the numerical formatting for those cells to a different option.
How to remove the percentage symbol from a cell in an Excel 2013 spreadsheet
Our article continues below with additional information on removing a percentage symbol in Excel 2013, including pictures of these steps.
How to Get Rid of the Percentage Symbol in Excel 2013 (Guide with Pictures)
The steps in this article were performed in Microsoft Excel 2013, but will work in most other versions of Excel as well.
Step 1: Open your file in Excel 2013.
Step 2: Select all of the cells containing the percentage symbols that you wish to remove.
Step 3: Right-click on one of the selected cells, then click Format Cells from the shortcut menu.
Step 4: Select the type of formatting that you would like to use instead of a percentage (I have selected Currency in the picture below, but you might prefer the Number or General option instead), then click the OK button at the bottom of the window.
If you change the formatting and the percentage symbols remain, then that means they were manually added to the cells. You can go through and delete those characters individually, or you can do a find and replace that looks for the percentage symbol and replaces it with nothing. Do you need to number all of the cells in a column with consecutive numbers? There is a faster way to do it that entering the numbers manually.
Additional Reading
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices. Read his full bio here.
