How do I make blank cells stay blank when merged

[1jazzylady45]

I have an excel file that I am trying to merge. It has donations in it and
some have $0.00, when I merge it with my form it puts "$0.00". If it is less
than $1 I want it to be blank. I have gone to mail merge helper and told it
to leave blank, but when I merge it still puts the 0 there.

When I put my merge field in place I right clicked and then toggled field
with \# $,0.00. I am not sure if that is my problem. I am at a loss.
Any help would be much apprecitated.

 

[Greg Collins [InfoPath MVP]]

I don't know if this will help in your situation or not, but if you choose Form Options from the Tools menu, and then look on the General tab, there's a check box at the bottom of that tab for "Treat blank values as zero".

Now I'm not quite sure where this option comes into play -- but it just might help you in your situation.

--
Greg Collins [InfoPath MVP]
Visit http://www.InfoPathDev.com


I have an excel file that I am trying to merge. It has donations in it and
some have $0.00, when I merge it with my form it puts "$0.00". If it is less
than $1 I want it to be blank. I have gone to mail merge helper and told it
to leave blank, but when I merge it still puts the 0 there.

When I put my merge field in place I right clicked and then toggled field
with \# $,0.00. I am not sure if that is my problem. I am at a loss.
Any help would be much apprecitated.