We appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Minitman" wrote in message
...
Thanks guys.

Pete that was a very good suggestion. And you are right, I did not
know how to tell excel that these numbers where hours and minutes.
Unfortunately, I could not use your suggestion it as it was. This is
in a data entry situation and there are too many other entries that
use the "." as a decimal.

RagDyer your work around to Pete's idea did the trick.

You both have my heart felt thanks for your help.

-Minitman




On Tue, 22 Jul 2008 16:54:42 -0700, "RagDyer"
wrote:

A nice option when using auto-correct is to use 2 decimal points
(periods -
dots) when you want a colon to display.
1..24 = 1:24
It's just as easy to enter them from the num keypad, and perhaps you may
not
even have to remove it when you're done.