|
You could always use a calcuation column to translate the input text structure to the correct structure for what Excel wants.
=LEFT(A1, 6) & ", " & LEFT(RIGHT(A1, 12), 10) & " " & RIGHT(A1, 2)
(Or something like that, that is all from my head and untested. This would convert Oct 5 1999 06:23AM to Oct 5, 1999 06:23 AM)
|