Date Reversal

[Shawn-UIA]

I regularly receive client spreadsheets where dates are listed as 20000328 (yyyymmdd) and have spent so much time trying to get it to convert to 03282000 (mmddyyyy). Or better yet mm/dd/yyyy. Is there anyway this can be done?

[#2 · Accepted solution]

Suppose that date is in cell A2:
=date(left(a2,4),mid(a2,5,2),right(a2,2))

[#3]

Thank you! I will give it a try. :)

[#4]

Thank you so much for the help! This is EXACTLY what I needed. :)