 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2007Have table formatted as currency and want all cells to show $0.00 when the formula value is ""
Hello, I have WORD 2003 and Win XPPro. I have a table, as show below that shows Assessed values of a fine -- Reduction amount of the fine -- and the total due of the fine. It is a mail merge document that draws information from an Excel spreadsheet/database. All of the cells appear to be formatted the same way and the formulas are all calculated the same. I need to show $0.00 all the time in the table boxes as indicated in the tables below. I actually need to display and print $0.00 in the Assessed column for three, the Reductions column 4th total cell and in the Total Due the Total due. Or if I can't get that settled then I would like to have all blanks in each, and when merged show the actual dollar value with the blanks as blank. Whichever.. I've tried everything that I can figure out with no luck. Any help would be greatly appreciated Thanks BOB Assessed Reduction Total Due «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» Assessed Reduction Total Due $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Hi Bob, It's not exactly clear what you're trying to do. So you've apparently got some headers: 'Assessed' 'Reduction' 'Total Due' and a bunch of mailmerge fields: «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» I don't see any formulae that might relate these to each other in any way. You also say "I need to show $0.00 all the time in the table boxes as indicated". I don't see a table - all I see is a single column with the above mergefields/strings followed by a repeat of what appears to be the header strings followed by some $0.00s. By "I need to show $0.00", do you mean you need the mailmerge results to show as currency? If so, select the mailmerge fields that need to be displayed this way, press Shift-F9 to expose the field code (eg «YECMP» becomed {YECMP}), then add a currency picture switch to the field, thus {YECMP \# $,0.00}. See Word's help file for more information on field formatting. This newsgroup is also replete with questions and answers about mergefield formatting. Cheers  Signaturemacropod [MVP - Microsoft Word] ------------------------- > Hello, I have WORD 2003 and Win XPPro. I have a table, as show below that shows Assessed values of a fine -- Reduction amount of > the fine -- and the total due of the fine. [quoted text clipped - 62 lines] > > $0.00 Thanks for the response. I've searched all over and am a little familiar with switches etc. I can't find an answer for this problem. As you can see each table cell that contains merge data is underlined.All are formatted with the switch that you provided, and that is like the {CSERACMP \# $,0.00} below. The underlined areas are each a cell, couldn't get the gridlines to print out, and where you see no $0.00 is formatted exactly the same as the ones with $0.00. My delima is I can't get all of them the same..... either without the $0.00 at all or show all with the $0.00. My apologies for not being clear before but I'm kinda at my wits end with this one. Thanks in advance. Bob Youth Employment Violation(s): $0.00 $0.00 Recordkeeping Violation(s): $0.00 $0.00 CSERA Violation(s): {CSERACMP \# $,0.00} $0.00 $0.00 Total: $0.00 > Hi Bob, > [quoted text clipped - 94 lines] >> >> $0.00 I did some more checking and found the original Excel database from where these are imported to have the $0.00, but only in some of the cells. So my question changes to one of would this statement work for all the cells??? IF { Mergefield "YECMP" } = "$0.00" "" "{ Mergefield "YECMP" } I think this will check and see if the value is $0.00 and return a blank and if not blank return the value.? Am I close. Thanks BOB > Thanks for the response. I've searched all over and am a little familiar > with switches etc. I can't find an answer for this problem. As you can see [quoted text clipped - 132 lines] >>> >>> $0.00 Hi Bob, Try embedding your mergefield in formula field coded as:: {=«YECMP» \# $,0.00} Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- >I did some more checking and found the original Excel database from where these are imported to have the $0.00, but only in some of >the cells. So my question changes to one of would this statement work for all the cells??? IF { Mergefield "YECMP" } = "$0.00" "" [quoted text clipped - 124 lines] >>>> >>>> $0.00 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.