How do I retain the exel number format in my mail merge document?

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>