Insert a decimal into a whole number. 100 to 1.00
put 100 in an empty cell, copy it, select the numbers and do editpaste
special and select divide, format as number with 2 decimals
--
Regards,
Peo Sjoblom
"Runner74" wrote in message
...
I have a larger amount of imported data that is in whole number form and I
need to insert a decimal. Change 100 to 1.00
|