I want to know why Excel multiplies numbers by 100 to calculate percentages?
Example, I have 15.00 but when I apply percentage formatting it goes to 1500% and then I have to go back in and edit. This makes no sense to me. I just need it to apply the % formatting not do calculations.
@Haytham Amairah is correct in his description that 15 is in fact 1500%. I just want to add a couple of things to this:
In excel, when you format a number as a percentage, by definition "Percentage formats multiply the cell value by 100 and displays the result with a percentage symbol." So, 15 would become (15*100)% or 1500%.
With that in mind, it is possible to display 15 as 15%. To do this, you may create a custom format of type 0.00##\%. This will turn 15 into 15% strictly from a visual point of view, however, the cell's value is still 15 or 1500% not 15%. So, if you were to use this cell in any further calculations (i.e. multiplying this cell by 2), keep in mind that you will by calculating with 1500% and not 15% (i.e. multiplying this cell by 2 becomes 30 or 3000% not 30%).
I would suggest that you manually change your cells to a percentage either by dividing by 100 (i.e. 15/100) or by adding a % to the end of the number (i.e. 15%).
@PReaganThanks both of you for your comments. Let me play with this. I need to test some things because I use lots of references in my calculations. Also, I'm spending too much time formatting inputs and I have to find a faster way to do this. I just can't keep doing the same thing everytime.