Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency formatting | Mailmerge | |||
Formatting for Currency | New Users | |||
Currency Formatting - Word 2000 | Mailmerge | |||
Formatting for Currency | Microsoft Word Help | |||
Currency formatting | Microsoft Word Help |