Need excel formula to convert a non-standard date format to another format
Posted on 2013-01-25
I have a column of "dates" that are in this format:
I am looking for a formula that will change the date to (in bold)
Mar-11-1969 031169 (MMDDYY)
Mar-07-2002 030702 (MMDDYY)
Mar-21-1999 032199 (MMDDYY)
On a side note: I have found that when I convert excel files with dates that start with a leading zero (as in 03) Excel will strip the leading zero from the date when exporting to a csv format. (I don't need date format, so if there is another format that will NOT strip out the leading zero (when exporting to csv) that would be great.)
Note: FYI Next month I will have a similar column that has this date format:
So in the formula you give me I will replace the Mar with Apr.
Hmmm... As I prepare this question, I am thinking it is a pretty simple question -- and it will expose me for the Excel ignoramus I am.