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" <[email protected]> wrote in
message news:[email protected]...
> 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.