Importing Data into Table View: Date Format dd-MMM-yyyy hh:mm:ss does not exist for date/time fields

Importing Data into Table View: Date Format dd-MMM-yyyy hh:mm:ss does not exist for date/time fields

I have a field (column) in the time and date format, e.g. 26-Oct-2010 11:30:00.  If I export as .csv or .xls and re-import immediately without modifying the file I am unable to import the time because the option "Date format for the column(s)" doesn't list  dd-MMM-yyyy hh:mm:ss, it only lists dd-MMM-yyyy.

This fix needs to happen fast because I have a lot to import.

thank you.