{IF {Mergefield Fieldname} "" "{Mergefield fieldname \# ",0.00"}"}
See also
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
MLL wrote:
I have formula's in Excel and merge the results in to a word
document. I need all results to retain the format of #.## and if the
result cell is empty, I want the merge field to be empty as well. I
have tried several switches but none of them accomplish all of my
needs.