Convert Text 01.03.2015 to Date 03/01/2015

[Johnnyboy1x]

Hello All --

I receive a daily file with dates formated as "general" with DD.MM.YYYY, but want to see MM/DD/YYYY

Ultimately, I am trying to Convert Text 01.03.2015 to Date 03/01/2015.

I tried to format cells as "date" but unsuccessful.

I also tried other things like replace all . with / , formatting as English UK then changing to US, etc. I just can't get there from here.

Thanks, John

 

[alansidman]

Assume data is in cell C13, then your formula would be: =DATE(RIGHT(C13,4),MID(C13,4,2),LEFT(C13,2))

 

[Johnnyboy1x]

Assume data is in cell C13, then your formula would be: =DATE(RIGHT(C13,4),MID(C13,4,2),LEFT(C13,2))

Thank You Alansidman! This worked perfectly!

John