Mail Merge Question

[J]

I am using a mail merge and the letters contain fields for gift
amounts. I am looking for a way to have dollar signs appear in the
fields which have a value greater than zero, but not appear
otherwise. The data I am pulling has no dollar signs. So, for
example, if the data in the field is 40 I would like the letter to
show "$40", but if it's zero or empty, no dollar sign would be
appended.

Any help is appreciated.

 

[Bob Umlas, Excel MVP]

Use a number format of $#,##0.00;;0 or $#,##0.00;;0.00