If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail merge field formatting from excel
I am trying to merge data from excel into word using mail merge. How do I
format the mail merge field so that it displays the currency figure or if the figure is zero it leaves the field blank |
#2
|
|||
|
|||
Mail merge field formatting from excel
You will; need a formatting switch eg
{Mergefield fieldname \@ "$,0.00;($,0.00); } See 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 Stuart wrote: I am trying to merge data from excel into word using mail merge. How do I format the mail merge field so that it displays the currency figure or if the figure is zero it leaves the field blank |
Thread Tools | |
Display Modes | |
|
|