# How to Change Date Format in Microsoft Excel

> To change the date format in Microsoft Excel, first highlight the cells containing the dates. Next, change the Locale to United Kingdom to apply the European date format. Then, choose the most suitable date format and click OK to automatically update the dates in your selected cells.

Canonical: https://livedemo.ai/tutorials/how-to-change-date-format-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30e3d673bd5aa8e63a3c/preview?step=1

## Steps

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