If you've got 1730 and you want 17:30, use =--TEXT(A2,"00\:00") and format
as time.
--
David Biddulph


"ahdoj" wrote in message
...
I'm sure the answers here, but I can't sort it out.

I have data entered as general number with no punctuation that needs to be
converted to military time. How do I convert it without losing the time
entered?