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.
Here is how to remove the percentage symbol from a cell in an Excel 2013 spreadsheet –
- Open the spreadsheet in Excel 2013.
- Select the cell(s) containing the percentage symbol(s) that you want to remove.
- Right-click one of the selected cells, then click the Format Cells option.
- Select the type of formatting that you would rather use, then click the OK button.
These steps are repeated below with pictures –
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.
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.