UK dates lose format with Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DGEB - 20 Jul 2006 15:52 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 20 Jul 2006 19:31 GMT

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

Signature

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

> 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?

Reply to this Message

DGEB - 20 Jul 2006 22:56 GMT

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

> See the "Dates: day/month reversed" item under the "Connection methods"
> topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
[quoted text clipped - 8 lines]
> > number format, e.g. 20 July 2006 becomes 7/20/2006. How can I preserve UK
> > format?

Reply to this Message