Date Formatting Issue

[robgriff]

I'm having problems with dates in Excel that are being formatted in the American style. Using VBA I'm building a .csv file and opening it in Excel with automation. The dates in the .csv file are formatted correctly but when the file is saved as an .xls file any dates that begin with a number less than 13 are being formatted as an American date (eg 01/10/2003 shows as 10/01/2003).

Is there a setting in Excel that dictates date formatting or does it rely on the regional settings on the PC?

Any suggestions appreciated.

 

[llkhoutx]

A date is a date is a date. A date's "format" only determines how it is displayed and does not change the date data value.

Converting a date to a string may allow you to do what you want.