Home

When will the next Excel AMA occur in 2019?

%3CLINGO-SUB%20id%3D%22lingo-sub-827806%22%20slang%3D%22en-US%22%3EWhen%20will%20the%20next%20Excel%20AMA%20occur%20in%202019%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-827806%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20ask%20the%20product%20managers%20about%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%20why%20Excel%20multiplies%20numbers%20by%20100%20to%20calculate%20percentages%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%2C%20I%20have%2015.00%20but%20when%20I%20apply%20percentage%20formatting%20it%20goes%20to%201500%25%20and%20then%20I%20have%20to%20go%20back%20in%20and%20edit.%20This%20makes%20no%20sense%20to%20me.%20I%20just%20need%20it%20to%20apply%20the%20%25%20formatting%20not%20do%20calculations.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWho%20made%20this%20decision%20to%20do%20it%20this%20way%20and%20why%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-827806%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Percentages%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-827932%22%20slang%3D%22en-US%22%3ERe%3A%20When%20will%20the%20next%20Excel%20AMA%20occur%20in%202019%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-827932%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3715%22%20target%3D%22_blank%22%3E%40George%20Carlisle%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20fact%2C%20Excel%20doesn't%20multiply%20the%20number%20by%20100%2C%20it's%20just%20changing%20the%20format%20of%20it.%3C%2FP%3E%3CP%3EThe%20integer%201%20is%20represented%20in%20the%20percent%20format%20in%20100%25.%3C%2FP%3E%3CP%3ESo%20when%20you%20format%20this%20number%2015%20(which%20is%20fifteen%20integers)%20as%20Percent%20the%20result%20is%201500%25.%20that's%20correct!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%201%20in%2015%20%3D%20100%25%3C%2FP%3E%3CP%3E15%20%3D%201500%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20check%20that%2C%20see%20the%20result%20of%20this%20formula%3A%3C%2FP%3E%3CPRE%3E%3D15%3D1500%25%3C%2FPRE%3E%3CP%3EThe%20result%20is%20TRUE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20apply%20the%20percent%20format%20without%20going%20back%20and%20edit%20the%20cell%2C%20you%20need%20to%20have%20this%20number%20instead%20of%2015.00%3A%3C%2FP%3E%3CPRE%3E0.15%3C%2FPRE%3E%3CP%3E0.15%20is%20a%20decimal%20number%20which%20is%20a%20fraction%20of%201%20integer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-828053%22%20slang%3D%22en-US%22%3ERe%3A%20When%20will%20the%20next%20Excel%20AMA%20occur%20in%202019%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828053%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3715%22%20target%3D%22_blank%22%3E%40George%20Carlisle%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3Bis%20correct%20in%20his%20description%20that%2015%20is%20in%20fact%201500%25.%20I%20just%20want%20to%20add%20a%20couple%20of%20things%20to%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20excel%2C%20when%20you%20format%20a%20number%20as%20a%20percentage%2C%20by%20definition%20%22Percentage%20formats%20multiply%20the%20cell%20value%20by%20100%20and%20displays%20the%20result%20with%20a%20percentage%20symbol.%22%20So%2C%2015%20would%20become%20(15*100)%25%20or%201500%25.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20that%20in%20mind%2C%20it%20is%20possible%20to%20display%2015%20as%2015%25.%20To%20do%20this%2C%20you%20may%20create%20a%20custom%20format%20of%20type%200.00%23%23%5C%25.%20This%20will%20turn%2015%20into%2015%25%20strictly%20from%20a%20visual%20point%20of%20view%2C%20however%2C%20the%20cell's%20value%20is%20still%2015%20or%201500%25%20not%2015%25.%26nbsp%3BSo%2C%20if%20you%20were%20to%20use%20this%20cell%20in%20any%20further%20calculations%20(i.e.%20multiplying%20this%20cell%20by%202)%2C%20keep%20in%20mind%20that%20you%20will%20by%20calculating%20with%201500%25%20and%20not%2015%25%20(i.e.%20multiplying%20this%20cell%20by%202%20becomes%2030%20or%203000%25%20not%2030%25).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20suggest%20that%20you%20manually%20change%20your%20cells%20to%20a%20percentage%20either%20by%20dividing%20by%20100%20(i.e.%2015%2F100)%20or%20by%20adding%20a%20%25%20to%20the%20end%20of%20the%20number%20(i.e.%2015%25).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps!%3CBR%20%2F%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-832527%22%20slang%3D%22en-US%22%3ERe%3A%20When%20will%20the%20next%20Excel%20AMA%20occur%20in%202019%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-832527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20discovered%20the%20answer%20today.%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20don't%20have%20to%20format%20the%20cell%20first...you%20just%20have%20to%20add%20%22%25%22%20or%20remove%20it(office%20AI%20might%20add%20it%20for%20you)%20after%20whatever%20you%20key%20in.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-828246%22%20slang%3D%22en-US%22%3ERe%3A%20When%20will%20the%20next%20Excel%20AMA%20occur%20in%202019%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828246%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3EThanks%20both%20of%20you%20for%20your%20comments.%20Let%20me%20play%20with%20this.%20I%20need%20to%20test%20some%20things%20because%20I%20use%20lots%20of%20references%20in%20my%20calculations.%20Also%2C%20I'm%20spending%20too%20much%20time%20formatting%20inputs%20and%20I%20have%20to%20find%20a%20faster%20way%20to%20do%20this.%20I%20just%20can't%20keep%20doing%20the%20same%20thing%20everytime.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
George Carlisle
New Contributor

I need to ask the product managers about Excel. 

 

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. 

 

Who made this decision to do it this way and why?

 

 

4 Replies

@George Carlisle

 

Hi,

 

In fact, Excel doesn't multiply the number by 100, it's just changing the format of it.

The integer 1 is represented in the percent format in 100%.

So when you format this number 15 (which is fifteen integers) as Percent the result is 1500%. that's correct!

 

Each 1 in 15 = 100%

15 = 1500%

 

To check that, see the result of this formula:

=15=1500%

The result is TRUE.

 

If you want to apply the percent format without going back and edit the cell, you need to have this number instead of 15.00:

0.15

0.15 is a decimal number which is a fraction of 1 integer.

 

Hope that helps

Hello @George Carlisle,

 

@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%).

 

I hope this helps!
PReagan

@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. 

Highlighted

@PReagan 

 

I discovered the answer today. 

You don't have to format the cell first...you just have to add "%" or remove it(office AI might add it for you) after whatever you key in. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies