Excel: change date format dates above = 13

i have a sheet of excel with date in the format dd/mm/yy i want to convert to mm/dd/yy i did that with the formula text(a1,"mm/dd/yyyy"). and dates below 12 got converted however dates above 13 and 13 are not changing as per desired format can somebody please guide me to get the formula for dates =13 and above 13

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of May 11, 2015.

For more resources for Microsoft Excel