Stop % showing in outcome of formula

[Guest]

Hi

I've got a formula that has returned an outcome in %, which is what I'm
after for that cell, but for my next formula linking to that cell I need the
formula to pick up the number not the percentage, ie its showing 50% but I
need it to pick up 50. Any help would be greatly appreciated

 

[Ken Wright]

If you just want the numerical part of the % then assuming it is in cell A1
use =A1*100 to give you that

I'm assuming here that you meant if for example cell A1 contained say 25%
representing 25% of say 200, then it is indeed the 25 from the 25% that you
want and not the 50 which is the actual value that the 25% represents.

 

[Arvi Laanemets]

Hi

With first formula in A1
=A1*100
(50% is same as 0.5) and format as Number or General


Arvi Laanemets