[Georgea]

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!

[Peter Jamieson]

The way you have it at the moment, the \# switch would apply to the
result of the IF field, and it won't work because you actually have a
text result. You need to put the switch inside the relevant fields, e.g.

{IF {MERGEFIELD "Charge" }"" "{ MERGEFIELD "#Months"} months @
{MERGEFIELD "AmtMonths" \# "$,0.00;($,0.00)" } /month" "" }


Peter Jamieson

http://tips.pjmsn.me.uk

On 08/01/2010 16:52, GeorgeA wrote:
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!

[Georgea]

Awesome, thanks!

"Peter Jamieson" wrote:

The way you have it at the moment, the \# switch would apply to the
result of the IF field, and it won't work because you actually have a
text result. You need to put the switch inside the relevant fields, e.g.

{IF {MERGEFIELD "Charge" }"" "{ MERGEFIELD "#Months"} months @
{MERGEFIELD "AmtMonths" \# "$,0.00;($,0.00)" } /month" "" }


Peter Jamieson

http://tips.pjmsn.me.uk

On 08/01/2010 16:52, GeorgeA wrote:
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!

.