Insert a decimal point

Originally Posted by alleyb

I have a cell with 5 digits in it ie 15555
I wish to change it to 1.5555
There are over 10,000 cells that I need to do this to. Is there a macro command that will allow me to
select all cells in range
insert decimal point after first digit

in a cell put .0001 and Edit, Copy the cell
Select the range and Edit, Paste Special = Multiply

hth
---

note, you can select a range by typing the address in the Name box, ie C1:C10000 <Enter>