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/cindy...r/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

"catherine" wrote in message
...
I have an Excel spreadsheet formatted to UK dating (5 April 2006) but in a
mailmerge the date is read the US way and appears 4 May 2006. How can I
change this?. My picture field switch in the Word document reads "dd MMMM
yyyy" and my Excel column is "[$-809]dd mmmm yyyy;@". I have tried
copying
the Excel formula into a date-time picture field switch without success.