This works for smart as well as lazy people:
http://tinyurl.com/r3ngw
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike" wrote in message
...
I want to type in 0700 in a cell and press <tab to go to the next cell and
it will auto format it like 07:00 (military time). ex: type in 1400 and it
display as 14:00, etc. In other words, I want to be lazy and not have to
type
the colon. How do I need to format the cell?
Thanks... Mike