To convert yyyy/mm/dd to mm/dd/yy, choose Data, Text to Columns, click Next twice, choose Date, select YMD, and click Finish.
Mar 05
To convert yyyy/mm/dd to mm/dd/yy, choose Data, Text to Columns, click Next twice, choose Date, select YMD, and click Finish.