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
|