"0" in empty column when converting from Excell data to Word direc

[Linda]

I have an Excell data base that I convert to a Word directory. It has
addresses, phone numbers, comments, etc. When it is converted to a directory
if there is no information in the Excell column then Word puts in a "0". I
want to get rid of that zero. How?

 

[Doug Robbins - Word MVP]

{ IF { MAILMERGE Nameoffieldthatsometimesreturnszero } = 0 "" "{ MERGEFIELD
Nameoffieldthatsometimesreturnszero }" }

You must use Ctrl + F9 to insert each pair of field delimiters and Alt + F9
to toggle off their display.

--
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