To show a number as percent in Microsoft Excel, you have to apply percentage number format in excel to that coloum. To apply this, select the cell, and then click the Percent button.
When you apply percentage formatting to a cell that already has number , Excel multiplies that number by 100 and adds the % sign at the end. Let’s type 10 into any cell and then apply the percentage on it show you 1000% not 10%.Let’s assume you type 10 on A2 cell and apply the formula =A2/100 it shows you 0.1% not 10% .
Then select that cell and click on the percentage button and you will see the result as 10%.
(Click on images to enlarge)