Find and Replace problem

[Glen in Orlando]

hello all...
first... thanks to all who offer their expertise..... this group has been a
wonderful asset.

My problem.... a few weeks ago I built a spreadsheet whereby I could enter
time quickly by simply typing, say, 12.45 and the spreadsheet would
automatically replace the . with a : on the fly. I set that find/replace
routine up so that I could use the number pad to enter the times on the fly.
Now, no matter what spreadsheet I open it will replace the period with a
colon. And for the life of me I can't figure out/remember how I set it up or
how to make it stop..... aaarrrggghh!

Help..

thanks to all

glen

 

[RagDyer]

If you say that you're having it change "on-the-fly", then you probably used
(are using) "Auto Correct".

<Tools> <AutoCorrect>
And find the period (.) that's being replaced with the colon ) and delete
it.

If I were you, I would use 2 dots (..), and have them replaced with the
colon, so that you wouldn't have to go and change it back every time.
It's just as easy to hit 2 decimals when you're adept at 10-key.

 

[Glen in Orlando]

Bingo...
thankyou sir...
and thanks for the tip... works like a charm...

glen

 

[RagDyeR]

Thank you for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Bingo...
thankyou sir...
and thanks for the tip... works like a charm...

glen