Assuming that you want to change the origonal cells, enter 100 in an unused
cell and copy it. Then highlight the cell you want change an right-click
and select Paste Special Divide

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Tom in Alaska" <Tom in wrote in message
...
I want to take a fixed number in a cell, like 84543421, and I want a
formula
that will display it as 845434.21 but I don't want to type the number over
again.