Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Georgea Georgea is offline
external usenet poster
 
Posts: 28
Default 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!

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Currency formatting within IF

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!

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Georgea Georgea is offline
external usenet poster
 
Posts: 28
Default 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!

.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Currency formatting PaddyWack Mailmerge 4 April 25th 08 07:15 AM
Formatting for Currency jayC New Users 1 February 1st 08 08:37 AM
Currency Formatting - Word 2000 Chris Stammers Mailmerge 8 May 13th 07 11:02 AM
Formatting for Currency Louisq Microsoft Word Help 2 July 14th 06 04:58 PM
Currency formatting MarkN Microsoft Word Help 7 January 19th 06 10:56 AM


All times are GMT +1. The time now is 02:11 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"