Mail Merge Decimals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neil - 17 Feb 2004 23:36 GMT

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

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 18 Feb 2004 02:32 GMT

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

\# "0.00"

Signature

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

> 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

Reply to this Message

Graham Mayor - 18 Feb 2004 06:17 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> 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

Reply to this Message