Try this:

Enter 0.01 in an empty cell
Copy that cell: EditCopy
Select the range of cells that you want to convert
Then: EditPaste SpecialMultiplyOK

Biff

"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.