See if this is good enough for you:

http://tinyurl.com/r3ngw

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steven Sinclair" wrote in
message ...
I'm trying to format a range of cells so that when I enter...

1348

Excel will interpret it as 1:48pm in military time.

However, I just can't seem to locate the correct format (if it even
exists).

Just want to be able to enter the time without the colon and have the
system
recognize it as a 24-hour format time.

Thanx.