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