Percentage

[jimboayr]

Hi guys,

i know there will be a simple solution to this.

How do I get for example 90.7% to show as .907.

Many thanks,

Jim

 

[Joe4]

Change the format of the cell to a Number with three decimal places.

 

[jimboayr]

When i do that it shows as 90.970

 

[Joe4]

It shouldn't, if the original number is 90.7%, as 100%=1, unless you started out using some special format.
What is the original format on that cell?

 

[Computerman]

Joe4,
I was thinking the same as you in just change the formatting. In testing to make sure that it worked I entered 90.7 into a cell that had General Formatting. I changed the formatting to Percentage and it change to what jimboayr got, 90.970. I re-entered it as 90.7 and it calculated correctly as .907. weird.
Computerman

 

[Joe4]

I was thinking the same as you in just change the formatting. In testing to make sure that it worked I entered 90.7 into a cell that had General Formatting. I changed the formatting to Percentage and it change to what jimboayr got, 90.970

I am not sure I understand what you are saying here. If you changed the format of a number to a percent, it should show a percent sign (and you did not post one in your explanation above).

If I enter 90.7 into a cell with General Formatting, and then change the format of that cell to a percentage, it shows 9070.00%, as expected (as 90.7 = 9070%).
However, if I enter 90.7% in a cell, and then change the format to a number with three decimals, it shows 0.907 (which is correct).

 

[jimboayr]

Guys,

this is how I getting my figure

A B C D
Mins Shots G/A Save%
2035 1000 93 90.7
To get 90.7 in cell D2 the formula I'm using is -
=SUM($C$4-$D$4)/$C$4*100
But I want cell E2 to show as .907
Hope this explains it

 

[Joe4]

Why are you multiplying by 100? That is why you are off by a power of 100!
Also, you do not need the SUM function. SUM is used to sum up a range of cells. You are just doing simple subtraction.
Just use:

=(C4-D4)/(C4)

 

[jimboayr]

Why are you multiplying by 100? That is why you are off by a power of 100!
Also, you do not need the SUM function. SUM is used to sum up a range of cells. You are just doing simple subtraction.
Just use:

=(C4-D4)/(C4)

Joe,

That is perfect just what I want.

Thanks

 

[Joe4]

You are welcome.

Note that is you ever want to display that calculation as a percentage, do not multiply it by 100. Simply change the formatting on the cell to be a Percentage, and it will display as 90.7%.