Insert a decimal into a whole number. 100 to 1.00
 

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

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

Insert a decimal into a whole number. 100 to 1.00
 

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.


Runner74 wrote:

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

--

Dave Peterson