I mail merge excell into word, but date displays numbers instead

[Chaya]

Example, instead of displaying 3/20/02 it displays 37335. How can I get word
to format the data from excell as date.

 

[Fred Smith]

In your mail merge document, you likely can tell Word what number format you
want (ie m/dd/yy). You could ask in the Word group about it.

The simpler option, to me, is to format the merged data in Excel, using
something like:

=Text(a1,"m/dd/yy")

Regards,
Fred.

 

[Bruce Sinclair]

In your mail merge document, you likely can tell Word what number format you
want (ie m/dd/yy). You could ask in the Word group about it.

The simpler option, to me, is to format the merged data in Excel, using
something like:

=Text(a1,"m/dd/yy")

Alternatively, try connecting to your excel file using DDE. That fixed a
number of formatting problems in the final word doc for me.