Cell Format from General
=TIME(LEFT(A1,2),RIGHT(A1,2),)
"S.C" wrote:
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
|