I am in the UK and I am trying to import a tab-delimited text file which
contains all dates in US date-time format, eg 03/14/2008 9:12:25 AM. I
import the file into Excel and it goes through the wizard. I set the date
field to MDY, but when I press Finish the dates appear either as a UK date
(when both month and day are less than/equal 12) or as text (when it cannot
convert). I have tried it by editing the text file and separating date and
time with tabs before importing and that works. But I don't want to have to
do editing like that.