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.