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
Word MVP web site http://word.mvps.org


AC wrote:
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"?