Date Formatting in Mail Merge

[AC]

I am trying to merge data from Excel into Word. The date is not displayed
correctly in Word. In Excel, the date is formatted to appear in the cell as
February 2, 2006, however in Word, it shows up as 2/2/06. How do I get Word
to appear as "February 2, 2006"?

 

[Graham Mayor]

You need a formatting switch on the field.
Press ALT+F9 to display the field construction
{Mergefield DateFieldName}
and add the switch between the brackets
{Mergefield DateFieldName \@ "MMMM d, yyyy"}
Press F9 to update and ALT+F9 to toggle the display back.

See http://www.gmayor.com/formatting_word_fields.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>