Conditionally formatting dollar amounts in Word merge

Elaine Murphy

Hello,


I am trying to format the gift amount field in our letter documents so that if it is a whole dollar amount, the decimal point and cents do not display, but if the amount includes cents, they do display. For example, $20.00 would display as $20, and $19.85 would display as $19.85.


I found a formula to modify the field to do this: { IF { = MOD({MERGEFIELD CnLGf_1Amount},1) } = 0 “{MERGEFIELD CnLGf_1Amount\\#$#,0}” “ { MERGEFIELD CnLGf_1Amount\\#$#,0.00}.


The formula works in Word (both Word 2010 and Word 2013) outside of Raiser's Edge, but it does NOT work when I generate the merge letter from the RE record.


Has anyone found a way to accomplish this? Thanks.

John Heizer

What results do you get when you do the merge from the RE record? 


Does Word show "Compatibility Mode" in the title bar? 


Using Word from within RE can often cause Word to revert to behaving like an older version of Word unless you create the merge document from scratch very carefully.

Elaine Murphy

No, it does not say "Compatibility Mode," it says Letter Document. I created a test document from scratch. Is there something I can do in the document setup to ensure it is using the latest version?