- 510K Members
- 4,137 Online
- 607K Conversations

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Home
- :
- Excel
- :
- General Discussion
- :
- Re: When will the next Excel AMA occur in 2019?

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Conversation Options

- Subscribe to RSS Feed
- Mark Conversation as New
- Mark Conversation as Read
- Pin this Conversation for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-28-2019 11:47 AM - edited 08-28-2019 11:52 AM

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?

Labels:

- Tags:
- Excel
- percentages

4 Replies

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-28-2019 12:57 PM

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-28-2019 01:31 PM

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-28-2019 03:20 PM - edited 09-02-2019 01:08 PM

@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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-31-2019 12:00 PM

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

Microsoft Office 2019 Now Available – Comparing 2019 🆚 2016 🆚 365, New Features in Access & Excel

Dan Moorehead | PowerAccess
in
Access
on
09-24-2018
256K
Views

8 Likes

20 Replies

Future of Microsoft Access: PowerApps｜CDS｜VSTO｜VBA｜Flow｜JS｜VS｜.NET｜Graph Cloud｜Mobile｜Web｜Developers

Dan Moorehead | PowerAccess
in
Access
on
03-29-2018
10.7K
Views

5 Likes

2 Replies

Join a Microsoft Excel AMA on October 17!

Christine Karambelas
in
Office 365
on
10-03-2019
162
Views

1 Likes

0 Replies

No option to Join insider program in Office 2019 pro plus

HotCakeX
in
Office Apps
on
08-05-2019
435
Views

1 Likes

2 Replies

Microsoft released Edge insider browser Windows Server Edition

HotCakeX
in
Discussions
on
11-02-2019
7,767
Views

0 Likes

1 Replies

Announcing a second AMA for Windows 7 Extended Security Updates

Heather Poulsen
in
Windows AMA
on
01-13-2020
3,787
Views

0 Likes

0 Replies

Share

Popular

Learning Resources

Programs

Values

- Contact us
- Privacy & cookies
- Terms of use
- Trademarks
- About our ads
- © Microsoft