Question: how to convert yymmdd to date in excel?
Answer: Thank you ! Change the cell's default date format from m/d/yyyy to yymmdd. Select the date cell then CTRL&1 to open the format cells window. Under the Number tab select Custom then under Type: enter yymmdd then OK.