format Date VBA

[Av8tordude]

I want to format the date output as "mm/dd/yy", however the code is not accomplishing what I want

Original code output display show 1/15/2019

Cells(SRow, 22) = Cells(RowNum, 3)

I tried this, but nothing happens. the output display show 1/15/2019

Cells(SRow, 22) = Format(Cells(RowNum, 3), "mm/dd/yy")

If i change the format to mmm/dd/yy, the output display show Jan/01,19.

Cells(SRow, 22) = Format(Cells(RowNum, 3), "mmm/dd/yy")

So clearly its doing something, just not want I want.

Can you help...thanks

 

[dmt32]

Hi,
Try

With Cells(sRow, 22)
    .Value = Cells(RowNum, 3).Value
     .NumberFormat = "mm/dd/yy"
End With

Dave

 

[Av8tordude]

Excellent... Thank you for your assistance dmt32....Cheers

 

[dmt32]

Excellent... Thank you for your assistance dmt32....Cheers

welcome - thanks for feedback

Dave