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

Highlighted

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. 

@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
47 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies