Convert Date Format

0 views
Skip to first unread message

Vibhuti Shrotriya

unread,
Feb 22, 2016, 9:59:35 AM2/22/16
to Excel VBA Lab - An Excel VBA Macro help Group
Dear All,


I have Dates in Column A in below format :

Feb22
Feb23
Feb24
Feb25
Feb26
Feb27


And, I want convert these dates in Below format :

22/2/2016
23/2/2016
24/2/2016
25/2/2016
27/2/2016


Kindly help.




Thanks & Regards
Vibhuti

Ashish Kumar

unread,
Feb 22, 2016, 10:39:05 PM2/22/16
to Excel...@googlegroups.com
Hi Vibhuti,


Check this.


Note : Please visit on forum page for download the sheet


Regards
Ashish Kumar
Date Format.xlsm

Md. Abu Jubair Sk.

unread,
Feb 23, 2016, 5:32:00 AM2/23/16
to Excel VBA Lab - An Excel VBA Macro help Group
I have learnt from this. Thank you very much.  

Ashish Kumar

unread,
Feb 23, 2016, 6:00:07 AM2/23/16
to Excel VBA Lab - An Excel VBA Macro help Group
Md. Abu Jubair Sk.

Cheers....!!




Regards
Ashish Kumar

Ashu K

unread,
Feb 27, 2016, 11:50:44 PM2/27/16
to Excel VBA Lab - An Excel VBA Macro help Group
code is working perfect.

Thanks for sharing.





Thanks & Regards
Ashu Kenith

Vibhuti Shrotriya

unread,
Feb 29, 2016, 10:33:41 PM2/29/16
to Excel VBA Lab - An Excel VBA Macro help Group
Dear Ashish,

Great work....!




Thanks & Regards
Vibhuti
Reply all
Reply to author
Forward
0 new messages