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

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Beginner" wrote in message
...
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

Hi

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


Arvi Laanemets


"Beginner" wrote in message
...
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