>Hi,
>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"   
>
>

>
>Please advise.
>Thanks
>Derek

I found this relevant thread and message Re: Strange date formatting Thread #1346235 Message #1346253 that may help.