We recently moved to Office 2003. We had a file in Excel 2000 that we used
to merge with a Word 2000 document for certificates. The date formatting in
the Excel document doesn't display in the Word document. It appears as
mm/dd/yyyy in Word and is formatted as month day, year in Excel. Why isn't
the formatting carrying over from Excel to the Word document? Any help would
be appreciated. Thanks.

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"djn" wrote in message
...
We recently moved to Office 2003. We had a file in Excel 2000 that we
used
to merge with a Word 2000 document for certificates. The date formatting
in
the Excel document doesn't display in the Word document. It appears as
mm/dd/yyyy in Word and is formatted as month day, year in Excel. Why
isn't
the formatting carrying over from Excel to the Word document? Any help
would
be appreciated. Thanks.