Hi Alex,

If the mergefield is numeric, you could control this by adding a numeric
picture switch to the field. For example,
\# $,0.00;($,0.00);
so that your field looks something like:
{MERGEFIELD ExcelData \# $,0.00;($,0.00);}
The string after the first semicolon tells the field how to format negative
values and the string after the last semicolon tells the field how to format
0s. In this case, there's nothing after the last semi-colon, so that tells
Word not to display 0s.

Alternatively, if you're merging text, you could control the output via an
IF test. For example:
{IF{MERGEFIELD ExcelData}= 0 "" {MERGEFIELD ExcelData}}

For more information, see:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=365442
(url all one line)

Cheers

Hi Alex,

See my reply from today in this message thread: Merging from Access

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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

Thanks. All suggestions did work

Thanks again !

alex