LiveDemo - Open-source alternative to Storylane, Navattic, and Arcade | Product Hunt

How to Change Date Format in Microsoft Excel


This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free


How to Change Date Format in Microsoft Excel: step-by-step guide

  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.

Quick answer: 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.

About this Microsoft tutorial

Quickly update and format date styles in Microsoft by highlighting cells, selecting a new locale, and choosing your preferred layout. This guide shows how to change Date Format in Microsoft Excel in 4 steps, starting with "Highlight the cells containing the dates you want to format" and finishing with "The dates in your selected cells will update automatically". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.

Frequently asked questions

How many steps does it take to change Date Format in Microsoft Excel?

4 steps. Each one is listed in order above, and the demo highlights exactly where to click.

Can I try it without changing my own account?

Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.

This tutorial is filed under Microsoft and Excel. Related guides: How to Change Field Size in Microsoft Access, How to Change Language in Microsoft Excel and How to Change Orientation to Landscape Microsoft Excel. Last reviewed 05 Oct 2026.

LiveDemo - Open-source alternative to Storylane, Navattic, and Arcade | Product Hunt
🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free→