using mail merge in Word 2002 fields come over from excel with 20.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

coco george - 17 Nov 2004 15:35 GMT

word 2002 mail merge from excel file, some fields come over with 20 decimal
places instead of what's in the cells of excel which is 4 decimal places. I
have tried formatting in execl as well as round function and nothing works. I
have tried doing same thing in word 200 and it works fine.

Reply to this Message

Fungus - 17 Nov 2004 15:40 GMT

Toggle on the field and add \##0.0000inside the "}" THen update

> word 2002 mail merge from excel file, some fields come over with 20 decimal
> places instead of what's in the cells of excel which is 4 decimal places. I
> have tried formatting in execl as well as round function and nothing works. I
> have tried doing same thing in word 200 and it works fine.

Reply to this Message

Graham Mayor - 17 Nov 2004 15:41 GMT

Word 2000 and 2002 use different methods of connection to their data files
for mail mrge. In this instance you need a formatting switch on the Word
field - http://www.gmayor.com/formatting_word_fields.htm

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> word 2002 mail merge from excel file, some fields come over with 20
> decimal places instead of what's in the cells of excel which is 4
> decimal places. I have tried formatting in execl as well as round
> function and nothing works. I have tried doing same thing in word 200
> and it works fine.

Reply to this Message