View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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