Problem formatting date as "dd/mm/yyyy"

  • Thread starter Thread starter Raj
  • Start date Start date
R

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
 
Try

dws.Cells(datarow, 3) = sws1.Cells(j, 6).Value
dws.Cells(datarow, 3).NumberFormat = "dd/mm/yyyy"
 
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
 
Back
Top