View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How can I insert a period into exsisting cells?

What's the rule where to insert it, will it always be inserted after the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a string of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM