Right click on the cells that you want to convert, then go to format cells.
In the category list of the number tab, you will have the choice of the time
settings that you can choose from (Under "Time" in the list)

Hope this helps.

Martin






"telewats" wrote:

>
> I am attempting to convert already existing data to military time. The
> existing data is dumped in from another program, and it currently looks
> like 5:58:08 a.m. and 3:01:29 p.m. I want them to show up 5:58:08
> and 13:01:29 (without the a.m. and p.m.)
> Users are currently using the "replace all" option to convert these,
> but it's a four-step process, and I keep thinking there has got to be
> an easier way! Can someone help?
>
>
> --
> telewats
> ------------------------------------------------------------------------
> telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
> View this thread: http://www.excelforum.com/showthread...hreadid=521817
>
>