How to Change Date Format in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to change date formats in Microsoft Excel step by step.

Quick summary

Changing the date format in Microsoft Excel lets you display dates in regional styles such as day-month-year by adjusting the Format Cells locale settings. Select your target cells, choose the right locale and date format, and Excel updates all selected dates instantly.

Steps

Select the cells containing the dates you want to format.
Open the Format Cells dialog to access date formatting options.
Change the Locale to United Kingdom to apply the European date format (day-month-year).
Choose the most suitable date format from the list, then click OK.
The dates in your selected cells will update automatically to reflect the new format.

📌 Why this matters

Knowing how to change the date format in Microsoft Excel is essential for anyone working with international data, reports, or shared spreadsheets across different regions. Excel's built-in locale-based formatting lets users instantly switch between date styles — such as MM/DD/YYYY and DD/MM/YYYY — without manually re-entering data. This prevents costly date misinterpretations that can affect financial records, project timelines, and data imports. Mastering Excel date formatting saves time and ensures data consistency across global teams.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel