Check this out.

http://www.cpearson.com/excel/DateTimeEntry.htm
--
Richard


"L. Roper" wrote:

In Exce 2002, is there any way to format a cell so that you can type 1345 and
have it appear as military time 13:45?

Thank you for your help.