Insert a decimal into a whole number. 100 to 1.00

R

Runner74

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
 
P

Peo Sjoblom

put 100 in an empty cell, copy it, select the numbers and do edit>paste
special and select divide, format as number with 2 decimals
 
D

Dave Peterson

put 100 in an empty cell
edit|copy (that cell)
select the range to fix
edit|Paste special|check divide

Clean up that cell with 100 in it and format the range you just fixed to show
the number of decimals you like.
 
Top