Is there any way to input a 4 digit number in the range 0000 to 2359
(represents time-of-day) and have Excell automatically insert the colons, ie
00:00? The cells are currently formatted as CUSTOM HH:MM. Forcing the user to
have to move the hand from the number pad to the alpha characters simply to
include the colon is annoying and inefficient.

I'm using MS Excell 2003 and my knowledge of cell formatting is extremely
limited.

TIA to all who may reply,
Deuxdad