English/American date formatting in XP mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Diston - 21 Jan 2005 16:17 GMT

I'm having a problem with taking data from Excel and merging it into labels
using XP mail merge. The problem relates to Word reformatting dates from the
English format (dd/mm/yyyy), as it was entered in Excel, to the American
format (mm/dd/yyyy) when using mail merge. Can anybody let me know how I can
get round this as I really need the dates to stay in the English format?

Thanks very much.

Reply to this Message

Doug Robbins - 22 Jan 2005 00:35 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

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> I'm having a problem with taking data from Excel and merging it into
> labels
[quoted text clipped - 6 lines]
>
> Thanks very much.

Reply to this Message