Incorrect date format using mail merge with Excel data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 19 Mar 2004 16:08 GMT

I am using Excel & Word 2002.
The date format in Excel is British but merges to Word in
the North American Format.
I cannot fing the converter that was available in
Word/Excel 2000.
Any help would be appreciated.
Thanks.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 20 Mar 2004 02:22 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 post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I am using Excel & Word 2002.
> The date format in Excel is British but merges to Word in
[quoted text clipped - 3 lines]
> Any help would be appreciated.
> Thanks.

Reply to this Message

Bob - 22 Mar 2004 14:33 GMT

Doug
That works a treat, so much so that I can force a number
of date formats (with or without hyphens).
It will speed up a number of mail merges I use.
Many thanks.
Bob

>-----Original Message-----
>See the "Dates: day/month reversed" item under the "Connection methods"
[quoted text clipped - 11 lines]
>
>.

Reply to this Message