«

»

Mar 05

Converting Dates In YYYY/MM/DD Format

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