[MLL]

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.

[Graham Mayor]

{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.