In mail merge I don't want to print blank fields

R

Richard

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

Doug Robbins

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
 
R

Richard

Where do I actually add the switch?

Doug Robbins said:
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
Click to expand...
 
Top