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

Doron Greenspan MITI  Identity Verified
Israel
Local time: 05:35
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: 04:35
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: 05:35
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: 04:35
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: 04:35
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: 05:35
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






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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