Problem merging dates from excel to word

[DeeAnne]

We are merging dates from excel into a word document. The dates are entered
in excel as 13/10/08 but are appearing in excel as random 5 digit numbers.
This isn't for all and so is a little confusing as all the dates are
formatted the same in excvel dd-mm-yyyy.

 

[Graham Mayor]

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button > Word Options > Advanced > General > Confirm file
format conversion on open). 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


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