Office - Excel - How to format dates

When report is run the date of birth will show i.e 21st January 2018 would like the format to be 21/01/18.

To format the date in the report as required after export to excel, please follow the below mentioned steps:

1. Select the ‘DOB’ column in the Excel report output.

2. Go to Menu Data |Text to Columns. A wizard will appear for the same.

3. Select ‘Delimited’ in Step 1 click ‘Next’, click ‘Next’ in Step 2. In Step 3, select the ‘Date:’ radio button. select ‘DMY’ from the drop down. click on Finish. The date will be formatted in the short date format.

4. Now go to Menu | Format | Cells | Date | Select the format like (dd/mm/yy) and click on ‘Ok’ | Date will be changed accordingly