Chip Pearson has some code that may help you:
http://cpearson.com/excel/DateTimeEntry.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

exsam21 wrote:

Is it possible for me to enter "1353" in cell A1 and it will
automatically display 1:53PM in cell A1? This would help a bunch.
Thanks.

--
exsam21
------------------------------------------------------------------------
exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666
View this thread: http://www.excelforum.com/showthread...hreadid=502566

--

Dave Peterson