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