Format an empty cell as Number. Enter the number 100 in it. EditCopy.
Select your cells to be divided. Paste Special, check Divide.

Always try new things on a copy of your workbook first.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"tuzdazchild" wrote in message ...
| need assistance in converting three columns of numbers (all 5digit) to insert
| the decimal 2 places in. I am only able to add decimal at end, which makes
| it 51322.00
|
| only other way is to manually change each cell, and that's about 3000 cells!
|
| please advise, and thanks, in advance for prompt reply.