Need help on converting General data to Date format

[bobbyexcel]

help Me to convert below referred cell data to date format. Need excel vba script to convert the below format of entire column and place it in next column in date format (whichever format is fine).

Tue Nov 19 20:00:28 CST 2019

 

[DanteAmor]

It worked perfect.. I have added .NumberFormat = "yyyy-mmm-dd" though since it is coming in number format. Anyhow, thanks much for your help.

It is correct, I commented from post # 2, you must put the desired format in the cells.

I'm glad to help you. Thanks for the feedback.