Put 100 in a cell copy it, select the range you want to divide and do
editpaste special and select divide
delete cell with 100, only one extra cell used To get 8.00 out of 800 you
need to use number format like
0.00 or else it displays as 8




--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Donna" wrote in message
...
Is there an easy way to move the decimal point other than adding a column
and
dividing by 100 then deleting wrong numbers?

THanks,
Donna