How about posting *SEVERAL* representative samples and let us know what
results you expect.

--
Biff
Microsoft Excel MVP


"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?