UK dates lose format with Mail Merge

[DGEB]

My data in Excel includes a column of dates which have been formatted for UK
English. When I mailmerge this data the dates change format to the US reverse
number format, e.g. 20 July 2006 becomes 7/20/2006. How can I preserve UK
format?

 

[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

 

[DGEB]

Thanks for referring me to the Meister site which looks very interesting. I
was able to solve my problem by formatting dates as text (as suggested).