Percentages and whole numbers

  • Thread starter Thread starter Treiva
  • Start date Start date
T

Treiva

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.
 
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 click>paste special>multiply.

Does that help?
 
Back
Top