Question: how to convert mmddyy to mm/dd/yyyy in excel?
Answer: Step1:select the range of cells that you want to convert, such as: B1:B4. Step2: go to Data tab in the Excel Ribbon, and click Text to Column command under Data Tools group. ...  Step5: you would see that the selected cells have been converted to a normal date format.