Hi Gabch,

Try:

Cells(1, 1).Value = DateValue("08/02/2006")


---
Regards,
Norman



"gabch" wrote in
message ...

Dear all,

Win local format is "dd/mm/yy"

in VBA

Cells(1, 1) = "08/02/2006"

in Excel sheet display

"02/08/06" in A1

What happen?


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=536337