Hi,

I have a csv file with dates in the format: 1/30/2007

When excel (2003 and 2007) imports the file it tries to switch the day
and the month:

e.g. It treats 10/12/2006 as 10 December instead of 12 October
When the date would make no sense this way, (e.g. 11/14/2006), it
imports this as text: "11/14/2006"

How can I correct this / or switch off the auto date correction?

It may be relevant that I'm Canada, where the day/month/year order is
sometimes used. I have tried changing my computer regional settings to
US rather Canada and have restarted Excel, but no luck.

Any suggestions much appreciated!