Excel date columns as text in Merges



Hi, I'm trying to do a mail merge between a Word Document and an Excel
spreadsheet. I'm using the latest ('07) versions of both programs.

I have several columns of dates in my data (such as original; billing date,
due date, etc.) I have them formatted as dates in Excel. My problem is
that when I do the merge, Word reads them as numbers such as 38982 or the

At first I thought I had an Excel problem, but now I'm thinking that I
should be able to format the merge field in Word to read the serial date as a
traditional date. Could you please show me how to keep Word from displaying
the dates as their serial numbers?

Graham Mayor

From Word Options and then go to the Advanced tab and check the box against
the "Confirm conversions at open" item. Then when you attach the data
source to the mail merge main document, you will be given the option of
using the DDE method of connection which should read the data as you have it
formatted in the table.

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question