how to convert ddmmyy to dd/mm/yyyy in excel?
In cell B2, type 20/05/2013, click the tick to the left of the Formula bar, then press Ctrl + E or click the Data tab, then click Flash Fill. Another possibility is to use Data – Text to Columns. As you go through the stages of the wizard, leave on default settings but in Step 3, click Date. Click Finish.