[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/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

"DGEB" wrote in message
...
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?

[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).

"Doug Robbins - Word MVP" wrote:

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

"DGEB" wrote in message
...
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?