How to switch US dates to Euro dates in Word
Thread poster: Doron Greenspan MITI

Doron Greenspan MITI  Identity Verified
Israel
Local time: 06:29
Member (2005)
English to Hebrew
+ ...
Oct 25, 2010

An interesting one, this:

I have about 30 Word docs where there are plenty of dates in US style (Month/Day/Year), and i'd like to change them in each doc into Euro style dates (Day/Month/Year).

Is there any smart way to do it using global Find & Replace?

Thanks, Doron


 

István Hirsch  Identity Verified
Local time: 05:29
English to Hungarian
With a regular expression Oct 25, 2010

http://word.mvps.org/FAQs/General/UsingWildcards.htm
(Example 2: Transposing dates)

[Módosítva: 2010-10-25 15:08 GMT]


 

Doron Greenspan MITI  Identity Verified
Israel
Local time: 06:29
Member (2005)
English to Hebrew
+ ...
TOPIC STARTER
Thanks, that seems just that - BUT one question... Oct 25, 2010

From your great reference, I was led to an even nearer one:

http://word.mvps.org/FAQs/General/TransposeDates.htm

But let me ask you this:

In that example, they show how to change 12/17/85 to 85/12/17
but I need to change 12/17/85 to 17/12/85 - how would I do that?

I tried moving the 'Replace With' placeholders around a bit, but it still doesn't get me where i want...

Thanks again, Doron


 

Gerard de Noord  Identity Verified
France
Local time: 05:29
Member (2003)
German to Dutch
+ ...
Should work Oct 25, 2010

Replace With:

\2/\1/\3

or

\2-\1-\3

Cheers,
Gerard


 

István Hirsch  Identity Verified
Local time: 05:29
English to Hungarian
An idea Oct 25, 2010

The replacement that Gerard suggested should work. Haven't you forgotten to check the "Use Wildcard" checkbox in Find and Replace window?

As for global replacement, if you mean you wish to transform the dates in all the 30 Word files in a single step, I think it is only possible with a macro.

István


[Módosítva: 2010-10-25 19:40 GMT]


 

Doron Greenspan MITI  Identity Verified
Israel
Local time: 06:29
Member (2005)
English to Hebrew
+ ...
TOPIC STARTER
Sorted - it was a Heb-specific issue Oct 26, 2010

Thanks Istvan and Gerard, apparently, after much experimenting, it appeared a Hebrew-specific (or BiDi-specific) issue.

The\2/\1/\3 did work, but was dislaying the date the other way round (2005/6/25).
So I added "English (US)" as another filter to both fields (Find ; Replace with) and now it's perfect.

Many thanks, I'm going to use that Word reference a lot!

Doron


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to switch US dates to Euro dates in Word

Advanced search






WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search