Convert Percent
 

Hello I have a column with pecents. I need to convert each percent into a
number that is if it reads 5% my answer should be 95 , 10% answer should be
90 etc thanks

Convert Percent
 

Suppose these are in C1:C20
In D1 (if that is used, then Insert | Column) enter = (1-C1)*100
Copy down to D20
If you do not need the old values; Copy D1:D20 and with the same range
selected use Edit | Paste Special with Values specified (formulas become
values)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wanna Learn" wrote in message
...
Hello I have a column with pecents. I need to convert each percent
into a
number that is if it reads 5% my answer should be 95 , 10% answer should
be
90 etc thanks