Add a decimal to each number on a list of whole numbers

[Will123]

I have a long list (column) of whole numbers (dollar amounts) and would like
to add a decimal point on each number. example change the numbers from
2927568021 to 29275680.21. I have tried changing the format, but it keeps
adding 2 zeros on the end. thanks

 

[Pete_UK]

You mean that you want to divide every number in that column by 100
(as in your example)? If so, then enter 100 into a blank cell
somewhere, select that cell and click <copy>. Then select all the
cells in the column of interest and Edit | Paste Special | Values
(check) | Divide (check) | OK then <Esc>. Then you can delete the 100
from the original cell.

You might need to change the format to Number with a display of 2
decimal places.

Hope this helps.

Pete

 

[Bob I]

put 100 in a cell, copy it, select the list of numbers paste special,
and select the Divide operation.