Merging Date field from excel source - imported in wrong date format

[inga]

My default regional settings for a date is dd/mm/yyyy (I'm
in Australia). In an excel data source as well is in any
other Office applications dates are defaulted to the
correct format dd/mm/yyyy, however when date fields are
merged into a document date format switches to mm/dd/yyyy.

I can't seem to find anything which would trigger this
switch, all my setting (Windows, Word, Excel) have a
correct default date format setup. I've re-installed the
MS Office but the error still persists. Could you please
assist in resolving this problem.

Many thanks in advance.

 

[Guest]

-----Original Message-----
My default regional settings for a date is dd/mm/yyyy (I'm
in Australia). In an excel data source as well is in any
other Office applications dates are defaulted to the
correct format dd/mm/yyyy, however when date fields are
merged into a document date format switches to mm/dd/yyyy.

I can't seem to find anything which would trigger this
switch, all my setting (Windows, Word, Excel) have a
correct default date format setup. I've re-installed the
MS Office but the error still persists. Could you please
assist in resolving this problem.
I use XP
Many thanks in advance.




.

 

[Jonathan Parminter]

-----Original Message-----
My default regional settings for a date is dd/mm/yyyy (I'm
in Australia). In an excel data source as well is in any
other Office applications dates are defaulted to the
correct format dd/mm/yyyy, however when date fields are
merged into a document date format switches to mm/dd/yyyy.

I can't seem to find anything which would trigger this
switch, all my setting (Windows, Word, Excel) have a
correct default date format setup. I've re-installed the
MS Office but the error still persists. Could you please
assist in resolving this problem.

Many thanks in advance.

Hi Inga,

you might like to view the article 320473
http://support.microsoft.com/default.aspx?scid=kb;en-
us;320473&Product=xlw

Actually, you also might like to review an earlier post by
Graham...

Subject: Re: Bug in Excel 2002 to Word merge?
From: "Graham Mayor" <[email protected]> Sent: 1/19/2004
8:26:23 AM

This is not a bug. It is intentional. Microsoft changed
the default method
of connection to data. Word is now expected to provide the
formatting. This
is easy to do with a switch on the merge field; or you can
revert to the
earlier connection method. Both options are discussed at:

http://www.gmayor.com/formatting_word_fields.htm
and
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
respectively

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>


Luck
Jonathan

 

[inga]

thank you Jonathan