Perhaps the column that comes across nicely is not really a date, but is
treated by Excel as text. You could use a formula like

=TEXT(A1,"dd-mmm-yyyy")

to display the value in A1 as a date in dd-mmm-yy format in another cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Suzanne" wrote in message
...
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