text to column date/time issues

[Lovecraft13]

I have an excel file that is a result of an oracle report feed with some 42,000 rows. I'm trying to split fields that contain both a date and time in it (mm/dd/yyyy mm:ss,0). After going through the "text to column" wizard, some of the values are still left in the original cell- it cuts off the first number on the time and leaves it with the date. It only does this on certain rows and I cannot find a rhyme or reason for it- probably stared at it for too long. I only discovered it after I had created a macro to insert all the new columns and separate the original values.
I don't know if I have given too much info or not enough (like how I changed the original data type in the wizard, etc).
Thanks!!