If you want Excel to use the Regional Settings for date formating,

[vba]
.NumberFormatLocal = "m/d/yyyy"
[/vba]

is the way to go

Paul