Excel doesn't now and doesn't care what date format is set in VFP. You shoul use unambiguous date format like YYYY-MM-DD. Formating how dates are displayed in Excel is different story.
>I have store a date value in a excel worksheet use dd-mmm-yyyy' format
>it should be 8 Dec 2011, but the result give me 12 Aug 2011 in the cell
>
>Why ?
>
>
>SET DATE TO DMY
>oExcel.activesheet.Range("C2").NumberFormat ='dd-mmm-yyyy'
>oExcel.activesheet.Range("C2").value = "08/12/2011"
>
>
--sb--