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:
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!
May 31 2007 12:00AM
This question generated 15 answers. To proceed to the answers, click here.
This thread is current as of December 08, 2015.