Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN I CONVERT A NUM IN WORDS (EXCEL) | Excel Discussion (Misc queries) | |||
Convert displayed number to absolute value | Excel Discussion (Misc queries) | |||
Percent Change | Excel Discussion (Misc queries) | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |