Posted to microsoft.public.word.mailmerge.fields
|
|
How do I correct how a birth date shows in a mail merge field?
Try this, Grace:
http://www.officearticles.com/word/m...osoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
"Grace" wrote in message
...
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?
|