So how does your data dump distinguish between 6am and 6pm?
--
David Biddulph

"PopTracker" wrote in message
...
I have a data dump that depicts 7:00 am as "700" and 5:00 pm as "500" (both
numbers.) I need to convert them to military time. Is there an easy way
to
do this? When I try formatting the cells as time they all change to
"00:00"
as excel attemps to convert the number into a date & time. Any guidance
is
appreciated.

Thanks