Mergefield syntax in WORD 2003

[Guest]

Where can I find MERGEFIELD syntax definitions?

I have a problem, as here follows:
I've made an EXCELL-file, in this excell-file a sheet, which cells are
generated with links to an another files cell (for example:
=[originalfile]originalsheet!$A$1).
It works correctly, but if the original cell has no data, the linked cell
will show 0 value.
This second excell file I used as a database for a document, with MERGEFILED
connected. In this word-document I won't to be showed zero values.
How can I make it?
I read somewhere, that MERGEFIELD has the options to use with switchers, but
about this I have no more infos.
HELP PLEASE! ITS URGENT FOR ME!

THANKS

 

[Jezebel]

Everyone's problem is urgent. If you type Mergefield into Word's help, the
field code explanation, and its switches, is the very first topic that comes
up.

 

[Graham Mayor]

See also http://www.gmayor.com/formatting_word_fields.htm but for this you
probably need a conditional field

{IF {Mergefield fieldname} <> 0 "{Mergefield Fieldname}"}

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

My web site www.gmayor.com

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

 

[Guest]

You might want to try this in Excel to eliminate the "0". Enter this in the
cell in which the 0 appears:
=If([originalfile]originalsheet!$A$1 = "","",[originalfile]originalsheet!$A$1)
I haven't tested this with your references to another workbook -- but it
should work. I use this frequently to eliminate 0s.