Format date

[Panoos64]

Hi i would like to change the format of month to date in col. "C" so to convert it, e.g. 10/2018 to 31/10/2018 using VBA.

Thank u all in advance

 

[Trevor G]

Try this code:

Sub Macro4()
Columns("C:C").NumberFormat = "m/d/yyyy"
End Sub

 

[Panoos64]

Thank you Trevor for your support. It works!

 

[Trevor G]

Happy to help and thank you for letting me know.