[Doug Robbins - Word MVP]

What version of Word?

For versions before 2007, from the Tools menu in Word, select Options and
then go to the General tab and check the box against the "Confirm
conversions at open" item. Then when you attach the data source, select the
DDE method of connection in the dialog box that will appear.

In Word 2007, that option can be accessed via the Office buttonWord
OptionsAdvanced and scroll down to the General section. The name is
slightly different - "Confirm file format conversion on open."

--
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

"Nadine" wrote in message
...
Why does this not work anymore...

Excel data source - has column with dates and formatted as MMMM DD, yyyy

Had no problem merging before, but now word changes the date to dd/mm/yy

Only way around it is to edit the merge field code and add the date switch
for the format.

Been using these excel documents and merge templates for very long time
and
had no problems with the date formats until now.

I changed regional settings, language, and date formats defaults, still
won't work without the switch.

Has there been some kind of update that has now caused this. Why is
working
like this now.

Thanks