How to Change Date Format in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Highlight the cells containing the dates you want to format.
2. Right-click on the selected cells and choose Format Cells from the menu.
3. Change the Locale to 'United Kingdom' to apply the European date format (day-month-year).
4. Choose the most suitable date format, then click on OK.
5. The dates in your selected cells will update automatically.