How to insert missing decimals

  • Thread starter Thread starter Cindy B.
  • Start date Start date
C

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?
 
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)
 
Back
Top