Date Formatting in Mail Merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"?
 
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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top