Do that twice, or use 100 instead of 10?
--
David Biddulph

"pinmaster" wrote in message
...
Hi,

One way: Type the number 10 in a blank cell then copy it, next select your
data and do a paste special/Divide.

"Tom in Alaska" wrote:

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.