convert ddmmyy to mmddyy

I wish to convert date from ddmmyy in the text format to mmddyy in the date format. Please tell me the formula to convert it in the mmddyy date format.

Nick's picture

it depends on how the date is

it depends on how the date is stored...

if it's stored as a date, then simply reformat the cell as "mmddyy"

if it's stored as a number, and in cell A1, you need to use
=MID(A1,2,2)&LEFT(A1,2)&RIGHT(A1,2)

If it's an American date that has been imported into Excel, and Excel has converted incorrectly into a European date, have a look here:
http://excelexperts.com/Excel-Tips-American-date-to-proper-date