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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MLL - 08 Nov 2006 17:32 GMT

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.

Reply to this Message

Graham Mayor - 08 Nov 2006 17:49 GMT

{IF {Mergefield Fieldname} <> "" "{Mergefield fieldname \# ",0.00"}"}

See also http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

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

Reply to this Message

Rate this thread: