Time Format: dd-MMM-yyyy hh:mm:ss cannot be imported into Table View

Time Format: dd-MMM-yyyy hh:mm:ss cannot be imported into Table View

I posted this a week ago under tips and tricks, asked customer service... no response.

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.



thank you.