Insert a decimal into a whole number. 100 to 1.00

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting a positive number to neg number in spreadsheets 3
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. 3
Mutiple IF(AND) too many conditions 7
decimal places and leading zeros 2
Sequentially adding a day to total 3
Decimal/Percentage to Whole Number 4
Fixed decimal places 2
Decimal 1

Back
Top