Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difficulties
i have over 3000 cells with values that i wont have time to re-enter i need
to know how to prevent excel from multiplying the values by 100 when i change the cells format to percentage. can anyone help me please thank you in advance -- help a friend help you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
difficulties
Try something like this:
Put 100 in a blank cell EditCopy Select the 3000 cells to be changed EditPaste Special Check: Divide Check: Values Click the [OK] button Now change the formats to Percents. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "ernie" wrote: i have over 3000 cells with values that i wont have time to re-enter i need to know how to prevent excel from multiplying the values by 100 when i change the cells format to percentage. can anyone help me please thank you in advance -- help a friend help you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
totaling difficulties | Excel Worksheet Functions | |||
Difficulties with COUNTIF. | Excel Worksheet Functions |