The data I get I have no control over how it is exported to me, since it is
in a word document makes it a pain.

Thanks for all of the suggestions .... they work and have cut my time in
completing my task

Thanks again



"S.C" wrote in message
...
I have several rows of data that were exported into a word document. I cut
and paste the data into a notepad document and save as text. I then import
the txt into a excel workbook.

My problem is that I have several columns of "times" (0702, 1340, 2250).
When I try to change the cell formatting too "time" it shows as 12 00 00
AM

Is there a way to format the cell and keep the actual time data?

Thanks in advance for any assistance.

Steve