Hi
you need vBA for this. See:
http://www.cpearson.com/excel/DateTimeEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Dan W." schrieb im Newsbeitrag
...
I am trying to type in 12:34 as 1234(for example) and have the format
convert
it back to 12:34 Is there a way of formatting this conversion? I will
need it
to be a time format since it is a time card key entry.

Thanks
--
Danlinksman