[Doug Robbins - Word MVP]

Click on the Office button and then on the Word Options button in the bottom
border and then on the Advanced button and scroll down to the General
section of the dialog and check the box against "Confirm file format
conversion at open." Then when you re-attach the data souce to the mail
merge main document, select the DDE option.

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

"Earl" wrote in message
...
I have two columns with dates in excel as mm/dd/yy, formatted the same, as
text.

Both are linked to the same word document and have the date format
switches
to month day, 20XX.

Conditional formatting is set-up for the sheet to alternate shading of
rows.

The secondary column displays the date but not text 'n/a' or anyother
text.

The primary column always has a date, but a test since this problem shows
it
will display text also.

This problem started with the use of Office 2007.

Thanks in advance