decimals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stan - 18 Aug 2006 03:28 GMT

i completed a mail merge. my word doc is displaying decimals up to 6 places
although excel is limited to 2. i tried using the switch mentioned on
http://www.gmayor.com/formatting_word_fields.htm but still didn't get it to
work.

below is my switch attempt and the results.
{ MERGEFIELD "Mailmerge_CPM_Credit_due"\# "$,0.00;($0.00)" }
0.47999999999999998

Any help would be greatly appreciated.

Reply to this Message

Graham Mayor - 18 Aug 2006 06:26 GMT

Did you update the field after adding the switch? It works for me as you
have written it.
Note that Word can get confused if you use overlong field names - like
yours!

Signature

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

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

> i completed a mail merge. my word doc is displaying decimals up to 6
> places although excel is limited to 2. i tried using the switch
[quoted text clipped - 6 lines]
>
> Any help would be greatly appreciated.

Reply to this Message