Just updated to Word 2003. When I merge with database held in Excel 2003
field with date changes from Australian format I typed in to American format,
eg 31/12/2004 changes in merged field to 12/31/2004. I've made sure my
settings are all set to use Australian everything but it still changes in the
process of merging. How do I fix this problem. I know that I can manually
change after fields have been merged but it is a real pain, I've never had
this problem in the previous versions of Word I have used. Any help would be
greatly appreciated. Thanks.

See the Excel data section of
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




NeetaV wrote:
Just updated to Word 2003. When I merge with database held in Excel
2003 field with date changes from Australian format I typed in to
American format, eg 31/12/2004 changes in merged field to 12/31/2004.
I've made sure my settings are all set to use Australian everything
but it still changes in the process of merging. How do I fix this
problem. I know that I can manually change after fields have been
merged but it is a real pain, I've never had this problem in the
previous versions of Word I have used. Any help would be greatly
appreciated. Thanks.

Thank you so much for your help.

"Graham Mayor" wrote:

See the Excel data section of
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




NeetaV wrote:
Just updated to Word 2003. When I merge with database held in Excel
2003 field with date changes from Australian format I typed in to
American format, eg 31/12/2004 changes in merged field to 12/31/2004.
I've made sure my settings are all set to use Australian everything
but it still changes in the process of merging. How do I fix this
problem. I know that I can manually change after fields have been
merged but it is a real pain, I've never had this problem in the
previous versions of Word I have used. Any help would be greatly
appreciated. Thanks.