Problem formatting date as "dd/mm/yyyy"

[Raj]

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

 

[Jacob Skaria]

Try

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

 

[Usman]

Hi,

Raj please format the destination cell as "dd/mm/yyyy"

right click the cell, click on format cell, select custom in number tab,
then in the Type box please type "dd/mm/yyyy" press ok

Regards,

Usman