[Stuart]

I am trying to merge data from excel into word using mail merge. How do I
format the mail merge field so that it displays the currency figure or if the
figure is zero it leaves the field blank

[Graham Mayor]

You will; need a formatting switch eg
{Mergefield fieldname \@ "$,0.00;($,0.00); }
See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Stuart wrote:
I am trying to merge data from excel into word using mail merge. How
do I format the mail merge field so that it displays the currency
figure or if the figure is zero it leaves the field blank