Date formats

[Guest]

When opening a csv sheet containg dates via a macro, all dates up to the 12th change to american format so 01/09/2004 (1st september 2004) becomes 09/01/2004 (9th january 2004)
Any help would be greatly appreciated.

 

[Dave Peterson]

Rename your .csv file to .txt

Then when you open it, you'll be prompted for each field. You can tell
explicitly to use mdy or dmy or whatever you want.

Alternatively, maybe you could try changing the windows regional settings to
match the data.

Windows start button|Settings|Control panel|regional settings applet|date tab

And see if that helped.