Why does Excel still show mm/dd/yyyy after I pick dd/mm/yyyy in Format Cells?

The most common cause is text storage. Click a single cell and look at the formula bar; if the value appears as 03/25/2026 with quotes or sits on the left side of the cell, Excel is treating it as text and will not accept a number format. Run Text to Columns with Date set to DMY first, then re-apply the dd/mm/yyyy custom format. The second cause is your computer's regional setting, which can override the cell format on some Excel builds.

Does reformatting a cell to dd/mm/yyyy change the underlying value?

No. Excel dates are serial numbers counted from a base date, and the dd/mm/yyyy layout is only a display mask. Any formula, chart, or pivot table that references the cell keeps using the same serial number. The display order is the only thing that changes, which is why formulas like =A1+30 still add 30 days rather than 30 calendar units.

How do I set dd/mm/yyyy as the default for every new Excel workbook?

Change your operating system region to one that uses day-first dates, such as English (United Kingdom), English (Australia), or any European locale. On Windows, open Settings > Time and Language > Region; on macOS, open System Settings > Language and Region. New workbooks will then default to dd/mm/yyyy. For a one-time Excel-only override, open File > Options > Advanced, uncheck Use system separators, and set the short date format to dd/mm/yyyy.

Can I show dd/mm/yyyy without changing the underlying cell?

Yes. Use the TEXT function with =TEXT(A1,"dd/mm/yyyy") to output the day-first text in another cell without touching A1. This is useful when you want to keep an imported column in mm/dd/yyyy for sorting but display a dd/mm/yyyy copy next to it for printing or for a colleague in Europe.

How to Change Excel Dates to dd/mm/yyyy Format

Excel stores every date as a serial number that counts days from a base date, so the dd/mm/yyyy layout you see on screen is just a display mask applied to that number rather than a separate piece of data. The fastest in-cell method is to select your dates, press Ctrl+1 to open Format Cells, pick Custom on the Number tab, type dd/mm/yyyy in the Type box, and click OK; every chosen cell updates at once. If your cells already display dd/mm/yyyy as text and the format refuses to take, the values are stored as text strings and have to be converted back into real serial numbers with Text to Columns or the DATEVALUE function before Excel will let you change the format. For one-off conversions outside Excel, such as a single date you want to paste into an email, a filename, or a legal document, the free Date Format Converter picks a date and shows the dd/mm/yyyy output alongside every other common format on its own copyable line, so you never have to type the digits by hand.

This article walks through the Format Cells route in detail, the text-string trap that catches almost every beginner, the small batch of regional settings that override your custom code, and the quick online fallback when you would rather not touch Excel at all.

how to convert date format in excel to dd/mm/yyyy

Why dd/mm/yyyy Is the Right Choice in Excel

The dd/mm/yyyy layout, sometimes called the European format, is used across most of the world, including the United Kingdom, Australia, much of the European Union, and most of Latin America. The United States uses mm/dd/yyyy by default, and ISO 8601 uses yyyy-mm-dd. Because Excel follows your computer's regional settings, the same file can look completely different when opened on a laptop in London versus a laptop in New York, even though the underlying serial number has not changed. Switching the column to dd/mm/yyyy is the cleanest way to make sure anyone opening the workbook sees the day first, regardless of their region.

Three practical reasons Excel users pick dd/mm/yyyy:

Clarity with double-digit days. Any date from the 13th of the month onward cannot be confused with a US format because there is no month 13 or 14, so 25/03/2026 is unambiguously 25 March.
Cross-team consistency. A dd/mm/yyyy column sent to a UK supplier reads correctly on first open without them having to reset their region or your reader having to flip the digits in their head.
Filenames and invoices. A filename such as Invoice_25-03-2026.xlsx is unambiguous in dd/mm/yyyy form and reads naturally for most non-US readers, although yyyy-mm-dd sorts better.

Change Excel Dates to dd/mm/yyyy in Format Cells

This is the standard built-in method that works on any selection of real Excel dates. Use it whenever your cells already contain serial numbers and you only need to change the display.

Open the workbook and select the cells, column, or range that holds the dates. To select an entire column, click its letter header.
Press Ctrl + 1 (Command + 1 on macOS) to open the Format Cells dialog.
On the Number tab, click Custom in the category list on the left.
Delete the existing content in the Type box on the right, then type dd/mm/yyyy.
Preview the sample row at the top of the dialog; the dates should now read day-first.
Click OK to apply the format to every selected cell.

For two-digit years, type dd/mm/yy; for four-digit years with dashes, type dd-mm-yyyy; for a month name, type dd mmm yyyy to get values like 25 Mar 2026. Excel treats all of these as the same underlying date; only the on-screen text changes, and any formula referencing the cell still uses the serial number.

When Excel Refuses to Switch to dd/mm/yyyy

If you run the Format Cells steps above and the dates do not change, or they line up on the left side of the cell instead of the right, the values are almost certainly stored as text. Excel cannot reformat text with a number mask, and no amount of clicking OK on the Custom box will fix it. There are three classic causes:

Imported CSV. Many CSVs export dates as quoted text such as "25/03/2026", and Excel treats the entire string as text rather than a serial number.
Leading apostrophes. A user typed the date with a leading apostrophe to force text mode, or pasted it from a source that did the same.
Mixed delimiters. Some cells use a slash, others use a dot or a dash, which prevents Excel from guessing the date pattern.

You can confirm text storage by clicking a single cell and looking at the formula bar. If the value shows 25/03/2026 with straight quotes, or if the cell shows a small green error triangle in the top-left corner, Excel is telling you the cell holds text. The Format Cells dialog will not fix that; the underlying data type has to change first.

Turn Text-Stored Dates Back into Real Dates

Once you have identified text dates, convert them in place so Format Cells can finally do its job.

Method 1: Text to Columns (best for large columns)

Select the text-date column.
On the Data tab, click Text to Columns.
Choose Delimited on step 1, then click Next.
Uncheck every delimiter on step 2, then click Next.
On step 3, pick Date and set the dropdown to DMY so Excel reads dd/mm/yyyy correctly.
Click Finish. The selected cells now hold real serial numbers in day-first order.

Pick DMY, not MDY. Choosing MDY would silently swap 25/03/2026 into the third of the 25th month, which Excel would then push into a far-off year and corrupt the column.

Method 2: DATEVALUE for one-off cells

Click an empty cell next to the text date.
Type =DATEVALUE(A1) where A1 is the text date, then press Enter.
If Excel returns a serial number, apply the dd/mm/yyyy format to this new cell.
Copy the result, choose Paste Special > Values back over the original, then delete the helper cell.

DATEVALUE also relies on your system locale, so a text string that reads 03/25/2026 may fail or shift months on a machine set to a dd/mm/yyyy region. Treat any ambiguous-looking string with Text to Columns first, where you control the DMY/MDY choice explicitly.

Copy the dd/mm/yyyy Output from a Date Format Converter

Sometimes the cleanest path is to step outside Excel entirely. If you have a single date you need as dd/mm/yyyy for an email subject, a filename, or a contract, open the Date Format Converter, pick the date from the calendar field, and read the dd/mm/yyyy line that appears next to the other common layouts.

The tool defaults to today's date, so picking a new date updates every line at once. You will see the ISO 8601 form (yyyy-mm-dd), the US form (mm/dd/yyyy), the European dd/mm/yyyy form, the long month-name form, the weekday form, the ordinal day, the date written in words, and the Unix timestamp, each on its own line with a Copy button. The dd/mm/yyyy and the European long form are both pulled from the same picked date, so they never disagree. Everything runs in the browser, so the date you enter never leaves your device and nothing is uploaded, with no signup and no limit on conversions. If you need to roll the date a few days forward or back before formatting, the Date Add Subtract Calculator gives you the shifted date in one click.

dd/mm/yyyy vs mm/dd/yyyy vs yyyy-mm-dd

All three formats display the same date in different orders, and the order changes how a reader interprets it. The table below compares the three layouts that cause the most cross-border confusion in Excel and CSV exports.

Format	Example for 25 March 2026	Order	Reads the same worldwide?	Best used for
dd/mm/yyyy (European)	25/03/2026	Day, month, year	Mostly, outside the US	UK, EU, AU invoices and dates
mm/dd/yyyy (US)	03/25/2026	Month, day, year	Only with US readers	US invoices and form fills
yyyy-mm-dd (ISO 8601)	2026-03-25	Year, month, day	Yes, every locale	Filenames, database columns, log files

Switch to yyyy-mm-dd the moment a column has to be sorted alphabetically, stored in a database, or used as part of a filename. ISO 8601 is big-endian, so 2026-03-25 sorts correctly as plain text and never has to be re-parsed by the receiving program. The Date Format Converter shows all three at once on its own copyable line, so you can pick the layout that fits the next step in your workflow.

Quick Troubleshooting for dd/mm/yyyy in Excel

A few short rules save hours when dd/mm/yyyy misbehaves:

Check your Windows or macOS region. Setting Windows Region to English (United Kingdom) makes Excel default to dd/mm/yyyy across new workbooks; setting it to English (United States) flips it back to mm/dd/yyyy. Region lives in Settings > Time and Language on Windows, and System Settings > Language and Region on macOS.
Use TEXT() for output, not reformatting. If you want one cell to read dd/mm/yyyy while the source keeps mm/dd/yyyy, wrap it with =TEXT(A1,"dd/mm/yyyy"). This is purely cosmetic and does not change A1.
Watch for #VALUE! errors. A dd/mm/yyyy format applied to a blank cell or a number cell returns a row of hash marks until the column is wide enough, or #VALUE! if the original was non-date text.
Save CSVs with ISO dates. When exporting from Excel, format the date column as yyyy-mm-dd first; many downstream tools still cannot parse dd/mm/yyyy reliably.

Most dd/mm/yyyy headaches in Excel trace back to either text storage or to a regional setting fighting the Custom code. Fix those two and the format sticks the first time.

If you're weighing options, Excel Age from DOB: Formulas, Pitfalls & Live Checks covers this in detail.