Excel Word - Mailmerge

[Guest]

One of our clients emailed a spreadsheet (don't know what version of Excel).
The data in the spreadsheet had to be merged into Word 2003 letters for
mailing. Before merging, I added two complete entries at the end. One of the
fields that was merged contained a date in the format 3/1/2006. However, the
date in the two entries I added did not print correctly in the Word letters
after merging. It came through something like 38675 instead of in date
format. Why would that be?

All the other entries were fine, except for the two I added at the end of
the spreadsheet.

 

[Dave Peterson]

Debra Dalgleish posted this to a similar question about formatting
dates/decimals.

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.