How do I stop Mail Merge from changing dates to USA format

[Jan Wachowski]

I have Excel & Word 2003.

I have created an Excel database with dates stored in Australian format ie
DD/MMM/YY

When I merge this into a word document it converts the dates to USA format
ie MM/DD/YY.

How do I stop this from occuring?

 

[Graham Mayor]

Use a date switch on your date field -
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[vetondenet]

Hi
I'm almost computer illiterate so didn't understand a word of Graham's site
(Thanks anyway Graham!) Anyway, my brother got me around the problem of
Americans and their rubbish inability to do things properly like the rest of
the world.. Copy the Excel sheet into word and then use that as your file for
importing into the mail merge. It doesn't solve the problem but it does
bypass it.

 

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Peter Jamieson]

Anyway, my brother got me around the problem of

Americans and their rubbish inability to do things properly like the rest
of
the world..

Gee, what on earth do you mean?

I'm not an American, but...

....you mean like Europeans nearly destroyed themselves twice in the 20th
century and were baled out by Americans who sacrificed their lives even
though they didn't really have to?

Or you mean like someone in Europe invented A1/A2/A3 paper sizes? That kind
of important thing?

Or what?

Peter Jamieson

 

[vetondenet]

Dear Doug,
Never visited this site since you gave that suggestion so apologies for the
delay in thanking you. Works perfectly!
Thanks again