Bug in Word 2003 (mail merge & date format)?

[Joao Luis Rita]

Hello all.

Just had a really weird situation. I have Office 2003 (portuguese)
installed. I imported an Excel 2003 file into access 97, then merged the
resulting table into a Word 2003 new doc. This table had a date field
formated for DD/MM/YYYY. When I merged, Word changed to the field to
MM/DD/YYYY and I couldn't find a way to undo this.
I then tried to merge from the original Excel 2003 file: same result. The
only solution I could find was to change the data field format from "date" to
"text" and re-merge...

I checked the PC's regional settings and they are ok.
As anyone had this problem?

 

[Bob Buckland ?:-\)]

Hi Joao Luis,

You may want to also post this in the MS Word Mailmerge group
(link below).

==========
Hello all.

Just had a really weird situation. I have Office 2003 (portuguese)
installed. I imported an Excel 2003 file into access 97, then merged the
resulting table into a Word 2003 new doc. This table had a date field
formated for DD/MM/YYYY. When I merged, Word changed to the field to
MM/DD/YYYY and I couldn't find a way to undo this.
I then tried to merge from the original Excel 2003 file: same result. The
only solution I could find was to change the data field format from "date" to
"text" and re-merge...

I checked the PC's regional settings and they are ok.
As anyone had this problem? >>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.mailmerge.fields
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.word.mailmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Joao Luis Rita]

Ok, did that. Didn't know that group.
Cheers