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.



11 views0 comments

Recent Posts

See All