If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"0" in empty column when converting from Excell data to Word direc
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? |
#2
|
|||
|
|||
"0" in empty column when converting from Excell data to Word direc
{ 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 "Linda" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|