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