Formatting in Mail Merge

[Michael Cullis]

I have a mail merge document which is sourced from an Excel worksheet. The
document is a doctor's account and includes fees for services. At present
mail merge prints .00 when the amount in Excel is blank. What I need to be
able to do is to show a blank if the Excel field is blank or the amount to
two decimal places (even if it is a round figure eg200) if it is not. So far
I I can do either one but not the other.

 

[Graham Mayor]

You need a formatting switch - see
http://www.gmayor.com/formatting_word_fields.htm
{Mergefield Fieldname \# ",$0.00;(,$0.00);"} should cover both bases.

If that doesn't give a blank for the empty field then either configure the
Excel data to have 0 on the field instead of blank or use a conditional
field

{IF {Mergefield Fieldname} <> ".00" "{Mergefield Fieldname \#
",$0.00;(,$0.00);"}" ""}

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


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

 

[Maureenf54]

My problem is the reverse, I'm merging from an excel spreadsheet, I need the
end zero to be visible in the word document after the merge. Ex. I need
$350.60 to show, but I get $350.6. Can you help?

 

[Doug Robbins - Word MVP]

You should try what Graham suggested.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Maureenf54]

Got it...thanks

You should try what Graham suggested.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP