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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Glen in Orlando" <(E-Mail Removed)> wrote in message
news:4sP4h.8898$(E-Mail Removed)...
> 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
>

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

glen


"RagDyer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Glen in Orlando" <(E-Mail Removed)> wrote in message
> news:4sP4h.8898$(E-Mail Removed)...
>> 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
>>
>

Thank you for the feed-back.
--

Regards,

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

"Glen in Orlando" <(E-Mail Removed)> wrote in message
news:CvS5h.10518$(E-Mail Removed)...
Bingo...
thankyou sir...
and thanks for the tip... works like a charm...

glen


"RagDyer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Glen in Orlando" <(E-Mail Removed)> wrote in message
> news:4sP4h.8898$(E-Mail Removed)...
>> 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
>>
>