 |
 | 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 / August 2004Is there a switch that will show no dollar sign if there's no data?
Hi, I'm using Office 2000 Pro and have a mail merge doc. using Word with Excel as the data source (which is a template, i.e. I copy it and use it for many different cases). Also, I merge the data from Excel to Word into Word tables. My question is this: Is there a switch that will show nothing in the table cell when no data is being merged? Sometimes a Word table will have all cells merged into it, and sometimes it will not. However, I want to have a switch with the $ sign in all of them since each case is different and I never know which cell will have data and which will not. Is there a switch that will show the dollar sign, but also be able to not show it if no numbers are merged to that particular cell? (I want to avoid showing zeros or zeros with $ signs if I can). I hope the question is clear enough, and thanks (as always) for the great help. See the section on suppressing zeros at http://www.gmayor.com/formatting_word_fields.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi, > I'm using Office 2000 Pro and have a mail merge doc. [quoted text clipped - 14 lines] > I hope the question is clear enough, and thanks (as > always) for the great help. Thanks so much for the website and help. What I'm having problems with is suppressing the dollar sign in a cell when no data is merged into it. Because, it appears that if no data is merged to the cell, the switch will cause there to be a dollar sign with no number following it. Can there be a switch that would suppress the dollar sign if nothing is merged to that cell? Thanks again, Jim >-----Original Message----- >See the section on suppressing zeros at [quoted text clipped - 20 lines] > >. In that case it needs a slight modification: {IF {Mergefield fieldname} <> "" "{Mergefield fieldname \# ",$0.00"}" } Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thanks so much for the website and help. What I'm having > problems with is suppressing the dollar sign in a cell [quoted text clipped - 38 lines] >> >> . Or, more simply: {Mergefield fieldname \# $,0.00;-$,0.00;} The \# $,0.00;-$0,.00; tells Word how to treat positive ($,0.00), negative (-$,0.00) and zero () values. In this case nothing displays for zero values because there is nothing after the second semi-colon. Note the correct placement of the commas. Cheers > In that case it needs a slight modification: > [quoted text clipped - 42 lines] > >> > >> . My web page demonstrates that method, but the OP responded that it wasn't working. The additional response was more brute force ;) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Or, more simply: > {Mergefield fieldname \# $,0.00;-$,0.00;} [quoted text clipped - 65 lines] > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.736 / Virus Database: 490 - Release Date: 9/08/2004 I really appreciate the inpu; your advice worked really well and you've helped me tremendously, thanks again. >-----Original Message----- >Or, more simply: [quoted text clipped - 59 lines] > >. That worked really well, you've really helped me out quite a bit. >-----Original Message----- >In that case it needs a slight modification: [quoted text clipped - 45 lines] > >.
|
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.