Percentages and whole numbers
 

Does anyone know how to convert numbers that get imported as percentages
converted to whole numbers?

Ex. 100% to 100, 80% to 80


Thansk for any help.

Percentages and whole numbers
 

One way.

Right click the cells where you hve the percentages go to Format Cells
Number tab select Number from the list. This will convert 100% into 1 and
80% into .8
Now type 100 in any blank cell copy that cell again select all the cells
right clickpaste specialmultiply.

Does that help?


"Treiva" <Treiva @discussions.microsoft.com wrote in message
...
Does anyone know how to convert numbers that get imported as percentages
converted to whole numbers?

Ex. 100% to 100, 80% to 80


Thansk for any help.