How to hide zero values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excel user - 16 Mar 2004 20:37 GMT

We would like to hide the zero values in a mail merge
from a work book with two excel sheets linked into word
2002 to create shipping labels with customers name,
quantity ordered and item name....problem that is
happening is that zeros are coming through for items not
ordered

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 17 Mar 2004 02:12 GMT

Add the following formatting switch to the mergefield

\# "0;-0;"

inside the closing } after you used Alt+F9 to toggle on the field codes.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> We would like to hide the zero values in a mail merge
> from a work book with two excel sheets linked into word
> 2002 to create shipping labels with customers name,
> quantity ordered and item name....problem that is
> happening is that zeros are coming through for items not
> ordered

Reply to this Message