Technical forums » Office applications »
How to switch US dates to Euro dates in Word
Thread poster: Doron Greenspan MITI
Doron Greenspan MITI
Doron Greenspan MITI  Identity Verified
Israel
Local time: 19:36
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
István Hirsch  Identity Verified
Local time: 18:36
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
Doron Greenspan MITI  Identity Verified
Israel
Local time: 19:36
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 b... See more
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 ▲ Collapse
 
Gerard de Noord
Gerard de Noord  Identity Verified
France
Local time: 18:36
Member (2003)
English to Dutch
+ ...
Should work Oct 25, 2010

Replace With:

\2/\1/\3

or

\2-\1-\3

Cheers,
Gerard
 
István Hirsch
István Hirsch  Identity Verified
Local time: 18:36
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
Doron Greenspan MITI  Identity Verified
Israel
Local time: 19:36
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:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

How to switch US dates to Euro dates in Word






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »