Changing European Dates to US Dates

Written by Allen Wyatt (last updated April 16, 2024)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021


4

Alan translates documents from languages that use the European date format (dd/mm/yyyy). Often these documents have many, many dates throughout them. It is very time consuming for him to change these dates into the US format (mm/dd/yyyy). Alan is wondering if there is a trick he can use to automate the change.

One way you can handle this is to use wildcards in Find and Replace. Here's how to set it up:

  1. Press Ctrl+H. Word displays the Replace tab of the Find and Replace dialog box.
  2. Click the More button, if it is visible. (See Figure 1.)
  3. Figure 1. The Replace tab of the Find and Replace dialog box.

  4. Select the Use Wildcards check box.
  5. In the Find What box, enter this: ([0-9]{2})/([0-9]{2})/([0-9]{4})
  6. In the Replace With box, enter this: \2/\1/\3 (See Figure 2.)
  7. Figure 2. All ready to replace.

  8. Click Replace All.

The key to how this works is in the search pattern used in step 4. This finds all instances of two digits, followed by a slash, followed by two digits, followed by a slash, and followed by four digits. Each grouping of digits (2, 2, and 4) is treated as a unit, and the "replace with" pattern (step 5) switches the first and second units.

This approach only works with date patterns that match what Alan specified: dd/mm/yyyy. If there are some dates that use single digits for the day or month or dates that use only two digits for the year, it won't work. You could modify the search pattern (step 4) to find dates that use either one or two digits for the day or month in this manner:

([0-9]{1,2})/([0-9]{1,2})/([0-9]{4})

Further, if your date format uses dashes between parts (dd-mm-yyyy), then you would need to modify the search pattern again:

([0-9]{1,2})-([0-9]{1,2})-([0-9]{4})

You would also need to modify the "replace with" pattern, accordingly, changing out slashes for dashes:

\2-\1-\3

Finally, if you use the Find and Replace method described here, you'll want to run it only once. If you run it twice, you will end up switching the day and month positions again.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13671) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and 2021.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Conditional Formatting for Errant Phone Numbers

Conditional formatting can be used to draw attention to all sorts of data based upon the criteria you specify. Here's how ...

Discover More

Freezing Top Rows and Bottom Rows

Freezing the top rows in a worksheet so that they are always visible is easy to do. Freezing the bottom rows is not so ...

Discover More

Incorrect In-Use Message

If you try to open a workbook that someone else has open, Excel lets you know of the conflict. What if Excel tells you, ...

Discover More

Do More in Less Time! An easy-to-understand guide to the more advanced features available in the Microsoft 365 version of Word. Enhance the quality of your documents and boost productivity in any field with this in-depth resource. Complete your Word-related tasks more efficiently as you unlock lesser-known tools and learn to quickly access the features you need. Check out Microsoft 365 Word For Professionals For Dummies today!

More WordTips (ribbon)

Replacing Just in the Footnotes

When editing a document that contains footnotes, you may want to perform a Find and Replace operation that is limited to ...

Discover More

A Fast Find-Next

Want a quick, easy way to "search again" for the next occurrence of what you need? Use the technique in this tip and ...

Discover More

Replacements Use an Incorrect Foreign Language Character

When using Find and Replace, it is possible that you might notice some surprising results when the replacements are done. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is eight more than 9?

2024-04-16 12:39:11

Barry

How about:
Description: Change numeric dates -- dd/mm/yyyy to mm/dd/yyyy
CAUTION: run twice and it will switch the dates back to what they were!!
BUT it means it works both ways i.e. American to European or European to American format.
Find What: <([0-9]@[/])([0-9]@[/])([0-9]{2,}>)
Replace With: \2\1\3
NB: Also works for dates listed as 5/2/23 etc.
I'm pretty confident that this covers the case where day or month is a single digit It also copes with the year being two digits.
If the separator character is anything other than "/" then change the Find What entry to suit.


2024-04-16 07:12:54

Jeff Parker

Would you please add how to do the transformation the other way, i.e. USA format to European/Australian?


2023-06-15 05:54:12

Aga

what can be the issue if I get the slashes (or whatever I put between the parts) after the numbers as a result like that:
09082021//?


2019-09-09 13:04:07

David Gray

Those find and replace formulas look like Perl compatible regular expressions and substitutions. I wasn't aware that Word supports regular expressions. That opens the door to some very powerful find and replace operations.


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Videos
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.