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.

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