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

C

Chaya

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

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

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")
Click to expand...

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