You're welcome. Thanks for the feedback!

Biff

"NWO" wrote in message
...
Excellent - thank you for the quick reply.

"NWO" wrote:

Hello.

I have an Excel time format of 6:00:00 AM. I need to (1) convert to
Military Time without the ":", then convert htis time to a text value for
import into an Access Database. All attempts to accomplish this on my
own
have not succeeded. Please advise of a suggested solution to this issue.

No code please.

Thank you.

NWO