Change Date Format in Excel

Open your workbook consisting of the date.

2. Select all the cells consisting of Date by pressing "Ctrl" and left click.

3. Right-click and choose "Format Cells".

4. Then from the location dropdown, choose the UK for setting the date in DD/MM/YYYY format.

5. Hit "OK" and your format has now been changed from "MM/DD/YYYY" to "DD/MM/YYYY".

6. Just above location you can also select the type of date you want to display.