You can set it up to work *temporarily* that way using "AutoCorrect".

Works well if you're entering timecards on a Monday morning, and you
wouldn't need it again till next week.

Just go to:
<Tools <AutoCorrect
And set it up to replace the period (decimal) with a colon.

When you're done, just change it back.
--
HTH,

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


"moskito" wrote in
message ...

How can i change the default setting for the time format from ":" to "."
for inserting time on num pad?


--
moskito
------------------------------------------------------------------------
moskito's Profile:
http://www.excelforum.com/member.php...o&userid=27813
View this thread: http://www.excelforum.com/showthread...hreadid=473229