Excel Date Field format in Mail Merge MSWord 2002

[Dick Appleby]

I am trying to merge Excel Data into a table in Word.
Whilst the data comes through ok, it changes the date
format from British 19/11/04 to 11/19/04.

Any ideas on how to stop this happening.

Also, once correct, how do I get it to show as 19th
November 2004?

Many Thanks
Dick Appleby

 

[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


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP