How can I surpress the printing of zeros in a field that is blank in the data
source (in this cace, Excel)

Version?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Richard" wrote in message
...
How can I surpress the printing of zeros in a field that is blank in the
data
source (in this cace, Excel)

2002

"Anne Troy" wrote:

Version?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Richard" wrote in message
...
How can I surpress the printing of zeros in a field that is blank in the
data
source (in this cace, Excel)

Don't use the Address Block. Instead, insert the merge fields separately.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Richard" wrote in message
...
2002

"Anne Troy" wrote:

Version?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Richard" wrote in message
...
How can I surpress the printing of zeros in a field that is blank in
the
data
source (in this cace, Excel)

Add the following format picture switch to the field

\# "0;-0;"

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Richard" wrote in message
...
How can I surpress the printing of zeros in a field that is blank in the
data
source (in this cace, Excel)

Where do I actually add the switch?

"Doug Robbins" wrote:

Add the following format picture switch to the field

\# "0;-0;"

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Richard" wrote in message
...
How can I surpress the printing of zeros in a field that is blank in the
data
source (in this cace, Excel)

Hit Alt+F9, Richard. You should then be able to view the merge fields so you
can edit it.
See:
http://www.officearticles.com/word/m...osoft_word.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Richard" wrote in message
...
Where do I actually add the switch?

"Doug Robbins" wrote:

Add the following format picture switch to the field

\# "0;-0;"

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Richard" wrote in message
...
How can I surpress the printing of zeros in a field that is blank in
the
data
source (in this cace, Excel)

I take it this is a number field - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Richard wrote:
How can I surpress the printing of zeros in a field that is blank in
the data source (in this cace, Excel)