Question: how to convert date from ddmmyyyy to dd/mm/yyyy?
Answer: 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.