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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grace - 31 Jan 2006 21:27 GMT

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?

Reply to this Message

Anne Troy - 31 Jan 2006 21:53 GMT

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

>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
[quoted text clipped - 9 lines]
>
> Any thoughts on what's going on?

Reply to this Message