Hi there
In office 2003, I merge an excel list containing some dates to a word
document. Sometimes (not every time), the date format changes from the
European version (e.g. 16/09/05) to the USA version (e.g. 09/16/05) in the
document, eventhough the European remains unchanged and correct in Word.
I've checked my regional settings in control panel and I've checked the cell
date format is ok in Excel.

Any help would be appreciated. I end up having to manually change each
merged document.

Rebecca

See http://www.gmayor.com/formatting_word_fields.htm and 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


Rebecca Dell wrote:
Hi there
In office 2003, I merge an excel list containing some dates to a word
document. Sometimes (not every time), the date format changes from
the European version (e.g. 16/09/05) to the USA version (e.g.
09/16/05) in the document, eventhough the European remains unchanged
and correct in Word. I've checked my regional settings in control
panel and I've checked the cell date format is ok in Excel.

Any help would be appreciated. I end up having to manually change
each merged document.

Rebecca