How do I correct how a birth date shows in a mail merge field?

[Grace]

I have 1/7/1953 as a birth date in my Excel data sheet. In another column
titled "Today's Date" I have 2/9/2006, and both columns are formatted EXACTLY
the same.

When I merge the labels, the Today's Date appears correctly as 2/9/2006. The
DOB column appears as 19366. The date 1/31/1955 shows as 20120. I do have one
birthday where I don't know the year so it's entered as 1/21/. This is the
only date that appears correctly in the merged document.

Any thoughts on what's going on?

 

[Anne Troy]

Try this, Grace:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com