Thread: How do I insert a decimal into a fixed number?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
  
Posts: 347
Default How do I insert a decimal into a fixed number?
Hi,

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

HTH
Jean-Guy

"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.
Reply With QuoteReply With Quote