Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mailmerge with Excel as a database... Suppressing zero's in fields
Hello,
Could someone help me with this? I am using an excel database to populate a form in Word. It is calculating dollar values and bringing them into Word. I can't seem to suppress the zero's in fields that should be blank because there is no value. I have been to G Mayor's site and tried what is there but it does not seem to work. Any suggestion's??? Thanks in advance, Mike |
#2
|
|||
|
|||
What formatting switch are you using?
To show positive and negative amounts but nothing for zero amounts, use: \# "$,0.00;-$,0.00;" or \# "$,0.00;($,0.00);" To just show the positive amounts, use: \# "$,0.00;;" -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Michael" wrote in message ... Hello, Could someone help me with this? I am using an excel database to populate a form in Word. It is calculating dollar values and bringing them into Word. I can't seem to suppress the zero's in fields that should be blank because there is no value. I have been to G Mayor's site and tried what is there but it does not seem to work. Any suggestion's??? Thanks in advance, Mike |
#3
|
|||
|
|||
Thanks for your input Doug. I tried earlier what you had suggested, but
somehow I could not get it to work. What I eventually used (and works well) was this: {if {mergefield fieldname} 0 "{mergefield fieldname}" } Thanks again! Mike "Doug Robbins" wrote: What formatting switch are you using? To show positive and negative amounts but nothing for zero amounts, use: \# "$,0.00;-$,0.00;" or \# "$,0.00;($,0.00);" To just show the positive amounts, use: \# "$,0.00;;" -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Michael" wrote in message ... Hello, Could someone help me with this? I am using an excel database to populate a form in Word. It is calculating dollar values and bringing them into Word. I can't seem to suppress the zero's in fields that should be blank because there is no value. I have been to G Mayor's site and tried what is there but it does not seem to work. Any suggestion's??? Thanks in advance, Mike |
#4
|
|||
|
|||
Did you update the field after adding the switch?
{Mergefield Amount \# ",$0.00;(,$0.00);" } should work. How did you enter it? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael wrote: Thanks for your input Doug. I tried earlier what you had suggested, but somehow I could not get it to work. What I eventually used (and works well) was this: {if {mergefield fieldname} 0 "{mergefield fieldname}" } Thanks again! Mike "Doug Robbins" wrote: What formatting switch are you using? To show positive and negative amounts but nothing for zero amounts, use: \# "$,0.00;-$,0.00;" or \# "$,0.00;($,0.00);" To just show the positive amounts, use: \# "$,0.00;;" -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Michael" wrote in message ... Hello, Could someone help me with this? I am using an excel database to populate a form in Word. It is calculating dollar values and bringing them into Word. I can't seem to suppress the zero's in fields that should be blank because there is no value. I have been to G Mayor's site and tried what is there but it does not seem to work. Any suggestion's??? Thanks in advance, Mike |
#5
|
|||
|
|||
Hi Graham,
Looking at your switch, I do believe that I didn't use the first comma. I am fairly new to this. I did although update the field. I am sure if I would have input the comma I would have had better results Mike "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Amount \# ",$0.00;(,$0.00);" } should work. How did you enter it? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael wrote: Thanks for your input Doug. I tried earlier what you had suggested, but somehow I could not get it to work. What I eventually used (and works well) was this: {if {mergefield fieldname} 0 "{mergefield fieldname}" } Thanks again! Mike "Doug Robbins" wrote: What formatting switch are you using? To show positive and negative amounts but nothing for zero amounts, use: \# "$,0.00;-$,0.00;" or \# "$,0.00;($,0.00);" To just show the positive amounts, use: \# "$,0.00;;" -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Michael" wrote in message ... Hello, Could someone help me with this? I am using an excel database to populate a form in Word. It is calculating dollar values and bringing them into Word. I can't seem to suppress the zero's in fields that should be blank because there is no value. I have been to G Mayor's site and tried what is there but it does not seem to work. Any suggestion's??? Thanks in advance, Mike |
#6
|
|||
|
|||
The first comma is the thousands separator. It will work in countries that
use a comma as such. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael wrote: Hi Graham, Looking at your switch, I do believe that I didn't use the first comma. I am fairly new to this. I did although update the field. I am sure if I would have input the comma I would have had better results Mike "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Amount \# ",$0.00;(,$0.00);" } should work. How did you enter it? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael wrote: Thanks for your input Doug. I tried earlier what you had suggested, but somehow I could not get it to work. What I eventually used (and works well) was this: {if {mergefield fieldname} 0 "{mergefield fieldname}" } Thanks again! Mike "Doug Robbins" wrote: What formatting switch are you using? To show positive and negative amounts but nothing for zero amounts, use: \# "$,0.00;-$,0.00;" or \# "$,0.00;($,0.00);" To just show the positive amounts, use: \# "$,0.00;;" -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Michael" wrote in message ... Hello, Could someone help me with this? I am using an excel database to populate a form in Word. It is calculating dollar values and bringing them into Word. I can't seem to suppress the zero's in fields that should be blank because there is no value. I have been to G Mayor's site and tried what is there but it does not seem to work. Any suggestion's??? Thanks in advance, Mike |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge from access database where query contains "fieldname like 'text*'" | Mailmerge | |||
WHEN MERGING EXCEL DATABASE, ERROR SAYS LOCKED FIELDS ? | Mailmerge | |||
Mailmerge on word using excel data | Mailmerge | |||
Mailmerge using Excel via DDE | Mailmerge | |||
Mailmerge from EXCEL, custom format problem | Mailmerge |