How to insert missing decimals

[Cindy B.]

I have several columns of numbers (monetary values) that
are missing the decimals. Such as 430000, which should be
4300.00. Is there an easier way to get the decimal in
without multiplying in another column and copying the
values back in?

 

[Peo Sjoblom]

One way

put 100 in an empty cell, copy it, select
your amount with the mouse and do edit>paste special, select divide.
Click OK. This assumes of course that all values need to be divided by 100
(or multiplied by 0.01)