Excel: Converting date to different format.


Hey, all. I receive a spreadsheet each day with up to 1000 rows. In two of these columns I am provided a date in a text formatted column with the following format:

May 31 2007 12:00AM
However, I need to put the date in MM/DD/YY format. I have tried my usual splitting, concatenate, etc... but I think due in part of it being a text based column in the first place, it is just now working. I am having to split them all, concatenate them, and then manually replace "May" with "5" and do that for each month. Obviously this is tedious and time consuming. Does anyone have any suggestions on how I can get to formatting this in a way that I could add into a macro? Thanks!


This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of December 08, 2015.


For more resources for Microsoft Excel