Change output of merged data HELP!

[Maly]

Hi

I have a table in a word document which holds data that
has been merged from Excel.

In one of the table columns, the field holds information
about loan amounts.

If the value is 0 this field is left completely blank but
what I would like to appear is a "-".

When I press Alt + F9 when on the "Write Letter" part of
the mail merge wizard, the Fields show this information.

{MERGEFIELD"F11"\#"#,###} with F11 being the column
from Excel.

What would I need to add to this in order to achieve my
goal?

Many thanks

Malcolm Davidson

 

[Graham Mayor]

You'll need a conditional field
{IF {Mergefield F11} <> "" "{Mergefield F11 \# ",#"}" "-"}
or
{IF {Mergefield F11} <> "0" "{Mergefield F11 \# ",#"}" "-"}

should do the trick
Use CTRL+F9 for the extra field boundaries {}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>