Mergefield syntax in WORD 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
Back
Top