Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I retain the exel number format in my mail merge document?
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I retain the exel number format in my mail merge document?
{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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
Mail Merge Data Question | Mailmerge | |||
Editing Mail Merge Recipients | Mailmerge | |||
Format Fractions in Mail Merge. | Mailmerge | |||
Locking a document with mail merge | Mailmerge |