date picker problem

[luolovepi]

Hi dear all,
I tested "Activesheet.DTPicker1.Value", and it returned a value "7/5/2011". But when I run the code below, the displayed value in cell G5 is 7.5.2011. How come? And I tried to change its data type in Home->Number, still can't have it to display as 7/5/2011. How can I format the displayed value? Why the displayed value format is different from the actual value format??

Activesheet.Range("G5").Value = Activesheet.DTPicker1.Value

Yours sincerely,
lolo^-^

 

[VoG]

Try

With Range("G5")
    .NumberFormat = "dd/mm/yyyy"
    .Value = ActiveSheet.DTPicker1.Value
End With

 

[luolovepi]

Thank you Peter. I ran your code but it still display "mm.dd.yyyy"...., but the value is indeed in mm/dd/yyyy format. What can I do with the display format?

Thanks!

Try

With Range("G5")
    .NumberFormat = "dd/mm/yyyy"
    .Value = ActiveSheet.DTPicker1.Value
End With