View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Date field in Excel loses format in Word merge

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

--

Graham Mayor - Word MVP

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


Cone wrote:
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.