>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.
If it's not broken, fix it until it is.
My Blog