€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides.
|
€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides. |
10-26-2006, 03:08 PM
|
#8 |
|
.
Join Date: Feb 2005
Posts: 13,354
  |
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) |
|
Submit to Quotes
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Threaded Mode