Currency formatting within IF
Hello,
I use a switch to format merge fields for currency (Word 2007 from Excel
2007) - \# "$,0.00;($,0.00)". This works until I have an IF statement. The
returned True option displays as 183.3300000001 (example) rather than
currency. I've tried placing the switch in different locations but I can't
get it to work.
{IF {MERGEFIELD "Charge" }"" "{ MERGEFIELD "#Months"} months @ {MERGEFIELD
"AmtMonths"} /month" "" \# "$,0.00;($,0.00)"}
Any help would be appreciated. Thanks!
|