>>I passed laHeader_Info[lnI,3] = "mm/dd/yyyy;@" but it made no difference. The dates are still 23-Jul-08
>
>Did you try just plain copy to ... XL5 ? If you have D field in VFP table, then I expect it will give you format mm/dd/yyyy automatically.

Hi Yuri,

I'm using COPY TO type XLS. I found that by using XL5 format the original name casing of the file is not respected.

I then apply the NumberFormat. I can try to not pass NumberFormat for dates, but I'm afraid the result would be the same.

Let me re-try without passing NumberFormat at all.