Change merged field value HELP!!!

[Malcolm]

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

 

[Cindy Meister -WordMVP-]

Hi Malcolm,

You want to create an IF field.

- select the entire Mergefield
- press Ctrl+F9 to insert field brackets { } around it
- edit it. Roughly:

{ IF { Mergefield F11 } = 0 "-" "{ Mergefield F11 \# "#,###"
}" }

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?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail