Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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!

 
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 07: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 09:56 AM


All times are GMT +1. The time now is 11:36 AM.

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"