mail merge word 2007

[pauline]

I am trying to merge fields from an excel database into a word document. All
is going well except that the numbers have extra decimal spaces when they
appear in the word doc. eg in excel $49.33, in word $49.3300000000000. I
have tried changing the excel document to different number types eg general,
accounting, text, number but nothing seems to work. Any Ideas?

 

[Graham Mayor]

Use a formatting switch on the mergefield eg

{Mergefield fieldname \# "$,0.00"}

see http://www.gmayor.com/formatting_word_fields.htm

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

My web site www.gmayor.com

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