Date format incorrect mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emily - 09 Sep 2004 06:47 GMT

I am using an excel 2003 file as my data source for my
word 2003 doc. Date format in excel is d/mm/yy.
Regional settings for date is also in short date format.
However, after mail merge the date format in the word doc
is mm/d/yy. I have office 2003 SP1. What shall I do to
make it to short date format?

Reply to this Message

Doug Robbins - 09 Sep 2004 10: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 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 am using an excel 2003 file as my data source for my
> word 2003 doc. Date format in excel is d/mm/yy.
> Regional settings for date is also in short date format.
> However, after mail merge the date format in the word doc
> is mm/d/yy. I have office 2003 SP1. What shall I do to
> make it to short date format?

Reply to this Message