show percentage formula result as a general number

[redspanna]

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

 

[redspanna]

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]

Re: shown percentage number as a GENERAL formatted number

Like this?
=AG9*100

 

[redspanna]

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

Appreciate your answer thought - thanks

 

[Peter_SSs]

Re: shown percentage number as a GENERAL formatted number

.. couldn't find out how to delete the post though

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]

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]

Can you do the following in cell AG10:
=AG9*100
and format this cell as General?

 

[Fluff]

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

 

[redspanna]

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

..didn't realise I had , sorry