



Now, Select “Divide” from operation area.Select cells with incorrect percentages, and press ALT+E S (alternatively right click and select Paste Special).To clean up incorrect percentages just follow these 4 steps. There must be some simple and intuitive solution for this … umm. ( You can not just format the cells to % format either, excel shows 23 as 2300% then). But what if you have 100s of rows of data. Now, you can very easily correct this by editing the cell and adding a % sign at the end. So instead of the value being 23%, it is 23. Sometimes we get values in our Excel sheets in such a way that the % sign is omitted.
