I have a .dbf file (tab delimited) which opens in excel. The start looks like this:

V900000/3 Deane-Jacobs (test), Ruth 12/06/2004 6:08:00 PM 5
V900000/3 Deane-Jacobs (test), Ruth 12/06/2004 6:10:00 PM 9
V900000/3 Deane-Jacobs (test), Ruth 18/06/2004 6:43:00 PM 5
V900000/3 Deane-Jacobs (test), Ruth 22/06/2004 10:45:00 AM 14
There is a problem with dates. All the computer settings are for uk culture. Excel switches some of the dates transposing the day and month if they are both less than or equal to 12, when it also removes the time.

How do i fix this? if it did it consistently on every row I could just set a dateformat for this column after it has opened, but why does it switch some and not others?

Adam