How to Suppress non-monetary 0

[kingswood]

Hello folks,

Mailmerge is new for me so I apologize for the elementary question. I have several fields in Excel that are blank. When these fields get mapped into the Word document, they are appearing as zero (0). If the value coming from Excel is blank, I want the field to display as blank on the Word document. Below is the latest example I have tried, but it does not work. Can someone help me with this? Thanks in advance.


{MERGEFIELD Petitioner_Att_Bar {IF {Mergefield Petitioner_Att_Bar} <> "" "{IF {Mergefield Petitioner_Att_Bar <> "0" "{Mergefield Petitioner_Att_Bar}" ""}" ""} \* MERGEFORMAT}