Mail Merge Decimals

[Neil]

When mail merging from excel, word is showing way more
decimals then exist in excel. eg excel is 10.10 and word
shows 10.99999999999999999



Thanks
Neil

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Toggle on the field codes with Alt+F9 and add the following numeric picture
switch inside the closing } of the offending mergefield

\# "0.00"

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>