Word ignores any formatting from Excel so you have to apply it in Word using
a formatting switch http://www.gmayor.com/formatting_word_fields.htm
In this case {Mergefield datefieldname \@ "MMMM d, yyyy"}

--

Graham Mayor - Word MVP

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


Elaine Ballon wrote:
I have an excel database with dates. I have formatted the dates in
excel so they are January 1, 2006 - When I do a merge using my excel
sheet as the information database, the columns that have the date
spelled out change to a date of 1/1/06. What can I do so the date
colums format does not change during the merge.