Date field in Excel loses format in Word merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cone - 24 Feb 2007 14:10 GMT

I have an Excel list that contains a numeric date field (I can clear the
formats from the field contents and I can see the underlying serial numbers).
The field is formatted using mmmm d, yyyy, which is the format I want to see
in the Word document. Problem: the Word document shows the contents of the
field as m/d/yyyy. How do I keep the original Excel format? (Using Excel
and Word 2002). Thanks.

Reply to this Message

Graham Mayor - 24 Feb 2007 15:13 GMT

Use a date switch on the merge field - see
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have an Excel list that contains a numeric date field (I can clear
> the formats from the field contents and I can see the underlying
> serial numbers). The field is formatted using mmmm d, yyyy, which is
> the format I want to see in the Word document. Problem: the Word
> document shows the contents of the field as m/d/yyyy. How do I keep
> the original Excel format? (Using Excel and Word 2002). Thanks.

Reply to this Message