Removing zeros from mailmerge labels

[J.Reynolds]

I am filtering, sorting, copying an excel sheet then pasting to a new sheet,
saving and closing, all by macro. When I use word to mailmerge the labels I
am getting zeros where cells are empty. If I select a new sheet in excel,
and look at the options the zero box is un-ticked. So how can I prevent
zeros showing in my labels?

 

[Graham Mayor]

Either use a conditional field to test for zero, or use a number mask to
inhibit the display of zero - see
http://www.gmayor.com/formatting_word_fields.htm

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


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