Most valuable professional
  • Hot Topics

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: Code: May 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 8, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel