Hi,

I am formatting cells using the following code: sws1 is the source
sheet and dws is the destination sheet.

dws.Cells(datarow, 3) = Format(sws1.Cells(j, 6), "dd/mm/yyyy")

The value of "31-03-2010" in sws1 is displayed as "31-03-2010" in
dws and not as "31/03/2010" as desired. The cell in dws is formatted
as general

The value of "12-03-2010" in sws1 is displayed as "03-12-10" in dws
and not as "12/03/2010" The cell in dws is formatted as date.

The dates in the sws1 sheet are formatted as dates

Please help iwith the correct code formatting to display as desired.

Thanks in advance for the help.

Regards,
Raj