show percentage formula result as a general number

redspanna

Well-known Member
Joined
Jul 27, 2005
Messages
1,462
Office Version
2016
Platform
Windows
Hi all

In cell AG9 I have a simple formula to work out a percentage value from two numbers in other cells.

so cell AG9 holds the formula =K14/500 and then cell AG9 if formatted as a PERCENTAGE, the result showing (with no decimal points) as 10


is there a formula to then show this result as a general number and not a percentage in another cell

so in cell AG10 the number 10 will be displayed and formatted as GENERAL


hope this make sense and thanks in advance
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

redspanna

Well-known Member
Joined
Jul 27, 2005
Messages
1,462
Office Version
2016
Platform
Windows
shown percentage number as a GENERAL formatted number

Hi all

In cell AG9 I have a simple formula to work out a percentage value from two numbers in other cells.

so cell AG9 holds the formula =K14/500 and then cell AG9 if formatted as a PERCENTAGE, the result showing (with no decimal points) as 10


is there a formula to then show this result as a general number and not a percentage in another cell

so in cell AG10 the number 10 will be displayed and formatted as GENERAL


hope this make sense and thanks in advance
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,731
Office Version
365
Platform
Windows
Re: shown percentage number as a GENERAL formatted number

Like this?
=AG9*100
 
Last edited:

redspanna

Well-known Member
Joined
Jul 27, 2005
Messages
1,462
Office Version
2016
Platform
Windows
Re: shown percentage number as a GENERAL formatted number

Thanks, I wanted to delete my post as I found an answer, couldn't find out how to delete the post though :eek:

Appreciate your answer thought - thanks
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,731
Office Version
365
Platform
Windows
Re: shown percentage number as a GENERAL formatted number

.. couldn't find out how to delete the post though :eek:
You can't delete posts as it can ruin threads if other posts have already been made. If you are within 10 minutes of posting it, you can edit and replace the content with something like "Solved"
 

redspanna

Well-known Member
Joined
Jul 27, 2005
Messages
1,462
Office Version
2016
Platform
Windows
Re: shown percentage number as a GENERAL formatted number

You can't delete posts as it can ruin threads if other posts have already been made. If you are within 10 minutes of posting it, you can edit and replace the content with something like "Solved"

Perfect - good to know for the future
 

JustynaMK

Well-known Member
Joined
Aug 28, 2016
Messages
630
Office Version
365, 2013
Platform
Windows
Can you do the following in cell AG10:
=AG9*100
and format this cell as General?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,087
Office Version
365
Platform
Windows
@redspanna
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).

I have merged both threads.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,788
Messages
5,470,789
Members
406,722
Latest member
Fcolombo

This Week's Hot Topics

Top