top of page

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.

17 views0 comments

Recent Posts

See All


bottom of page