Posted to microsoft.public.word.mailmerge.fields
|
|
Currency formatting within IF
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!
.
|