I've asked this in the Word group, but have not been able to resolve the
problem.

I am merging Excel data to Word (via mail merge). Three columns (D, E, &
L) on the worksheet are dates and are formatted exactly the same.

Col D & L show up in Word as serial numbers.

Col E shows up as a date.

I've tried putting a switch on the Word document (no success).

I've tried the DDE route, but Word only picks up the first worksheet (this
one is the 6th one in and cannot be moved as the workbook is set up in a
required sequence). Word also stops looking at the data when it encounters
an empty field (the 'comments' field will usually -- but not always -- be
empty).

Any ideas??

Thanks -- SuzLeigh