Excel Convert European Dates to US Format

Updated 10 November 2026 · Standard formula, shown below

To convert European-style dates in Excel to US-style month/day/year, first check whether Excel recognizes the entries as dates; then change the cell format or convert the text to real dates. A display-format change is enough for date values, while text such as “31.12.2025” may need a formula or import conversion before it can be displayed as “12/31/2025.”

Check Whether Excel Sees a Date

Dates in Excel are normally stored as serial numbers and shown according to a cell’s number format. A cell that looks like “31/12/2025” may already contain a valid date, with the day-first appearance coming only from its format. Alternatively, it may contain text characters that Excel has not interpreted as a date. Those two cases require different fixes.

Select a cell and look at the formula bar. A recognized date generally appears as a date value there, though its exact appearance can depend on Excel’s settings. A quick test is to change the cell’s format temporarily to General: a recognized date typically becomes a number, whereas text usually stays unchanged. Undo the test or reapply the desired date format afterward. Do not rely on appearance alone; text can look exactly like a date.

Change the Display Format for Real Dates

If Excel already recognizes the values, format the cells to show the US order. This changes how the date is displayed, not the underlying date or its meaning.

Select the date cells or the whole column.
Open the cell-format dialog. In Windows, press Ctrl+1; on Mac, use Command+1. You can also right-click the selection and choose Format Cells.
Choose the Number tab, then Date, and select a month-first example such as 3/14/2012. If the listed choices do not give the layout you need, choose Custom.
For a custom format, enter mm/dd/yyyy for a two-digit month and day, such as 12/31/2025. Use m/d/yyyy if you prefer values such as 1/5/2025.
Select OK and check several cells, including dates near the start and end of a month.

In a custom date format, m represents the month, d the day, and y the year. Repeating a letter controls how many digits are shown. To include a weekday, for example, a format can include ddd or dddd. A format such as mm/dd/yyyy does not turn a day-first date into a different date; it only changes the display.

Convert Date Text with Text to Columns

When entries are text, changing the number format usually has no effect. If the text follows a consistent order and uses a separator such as a slash, dot, or hyphen, Excel’s Text to Columns tool can parse it as a date.

Make a copy of the original column or work in a new column, so you can compare the results.
Select the cells and choose Data > Text to Columns.
Choose Delimited and proceed through the wizard. If the date entries do not contain fields that should be split, leave the delimiter choices configured so the date is treated as one column.
In the column data format step, choose Date and select the order that matches the source, such as DMY for day-month-year. Choose the correct order for your actual data, not the US order you want to display.
Finish the conversion, then format the resulting date cells as mm/dd/yyyy.

The source order matters. For example, the text 04/05/2025 could mean April 5 or 4 May. Excel cannot infer the intended meaning from those digits alone. If you choose the wrong source order, the result may be a valid but incorrect date, so check unambiguous examples such as a day greater than 12.

Use a Formula for Consistent Text

A formula can help when text dates are consistent and you need to preserve the original column. For text in A2 written as dd/mm/yyyy with slashes, a formula that builds a date from its parts is:

=DATE(VALUE(RIGHT(A2,4)),VALUE(MID(A2,4,2)),VALUE(LEFT(A2,2)))

This formula assumes the day occupies the first two characters, the month the next two, and the year the last four, with slashes in fixed positions. Fill it down, then format the results as mm/dd/yyyy. For another separator or variable-width fields, adjust the formula or use a more suitable parsing method. If your Excel uses semicolons between formula arguments, replace the commas with semicolons.

For text in the ISO-like order yyyy-mm-dd, Excel may recognize the value during import or conversion, but recognition depends on the data and settings. Avoid applying a formula written for one pattern to a column containing multiple patterns.

Import Settings and Regional Ambiguity

For a CSV or text file, the safest approach is to set the source date order during import rather than letting Excel guess. Use the data import workflow available in your Excel version, select the relevant column, and specify the source format if the preview or transformation options allow it. Then apply a US display format after the values have been interpreted correctly.

Excel’s regional settings can affect how typed dates and imported text are understood. The same string may be read differently on two computers. A month-first format in the worksheet does not change the computer’s regional settings, and changing regional settings is not necessary merely to display a column in US order.

For reliable exchange between systems, use an unambiguous date representation in source data when possible, such as 2025-12-31, and confirm how the receiving application interprets it. Be especially careful with dates where both the first and second numbers are 12 or less: they do not reveal whether the source is month-first or day-first.

Common Problems and How to Check the Result

The format has no effect: The cells may contain text. Convert them to date values first, using Text to Columns, a suitable formula, or import settings.
Some dates convert incorrectly: The column may mix date orders, or the chosen source order may be wrong. Compare against a known date with a day greater than 12.
Hash marks appear: Excel may not have enough column width to show the date. Widen the column before assuming the value is damaged.
A date displays as a number: It may be a valid date shown with General or numeric formatting. Apply a date format.
Different separators appear: The displayed separator may follow the format or regional settings. Use a custom format if you need a particular appearance, and verify it on the target system.

After conversion, check the formula bar, sort the column, and test a few dates against the original source. A valid date column should generally sort chronologically rather than alphabetically. If you used formulas, copy the results and use Paste Special > Values if you need fixed date values instead of formulas; retain a backup of the source until the results are verified.

Frequently Asked Questions

How do I change European dates to US dates in Excel?
Select the cells, open Format Cells, and choose a month-first date format such as mm/dd/yyyy. This works when Excel already stores the entries as dates.

Why does changing the date format not work?
The entries are likely text rather than Excel date values. Convert or import them using the correct source order, then apply the US display format.

Does changing the format change the actual date?
No. Formatting changes the displayed order, not the stored date. A separate conversion is needed if Excel interpreted the original text as the wrong date.

How can I tell whether a date is day-first or month-first?
Check the source documentation or an unambiguous entry where one number is greater than 12. A value such as 04/05/2025 alone cannot distinguish the two interpretations.

Can I convert dates when importing a CSV?
Yes. Set the date order for the column during the import or transformation process when that option is available. Confirm the parsed values before saving the workbook.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.