Convert "General" format to "Date" format using VBA

[xlhelp15]

Hello Genius,

Kindly help me on the below requirement.

Actually I have data in the format of "General" which has Date & Time in that. I need to convert it to Date format.

From : Dec 5 2018 2:46PM

to : 12/05/18 or 12/05/2018.

Your help is greatly appreciated !

Thanks.

 

[Joe4]

You can get this VBA code very easily yourself.
All you have to do is turn on the Macro Recorder, and record yourself manually changing the format of a cell to your desired format.
Then stop the recorder and view your code.

This is a great way to get simple code snippets without having to know how to write VBA.