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.