G Guest Jun 28, 2007 #1 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
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 Jun 28, 2007 #2 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
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 Jun 28, 2007 #3 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.
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.
