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

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

There is apparantly no resolution to this problem. The work-around was
change the format of all my date fields to 'Custom: ##-##-####' (to obtain
MM-dd-yyyy).

Fortunately, the outcome of this particular workbook does not depend on date
queries; any future workbooks which (1) will be merged to Word and (2)
contain date-targeted queries, will probably require further adjustment.

suzleigh

"Suzanne" wrote:

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