CarlCarl 0 Newbie Poster

I am running a mail merge and the excel sheet uses lookup formulas, the problem I am having is that on the merged word doc the cells that have a zero value are coming out on the word doc. Is there a way that I can do the merge so that the cells with zero value do not transpire across?