solution needed to prevent empty merged cells showing on document as a zero
I use word 2003 and I am merging from Excel
I am making a lease, the excel documents allows up to 12 people on the lease if there are only 6 or 8 I have many entries on Word that just show up as lower case zeros. this is also true if the person filling in the excel sheet skips a cell so that perhaps whilst 5 address lines are needed only three are used . If the default value were to be $ or # then I could find and replace - but with a zero so much else goes with it .
Is there a setting in excel or Word that can sort this or do I have to re word each formula if so is thee a setting that ensure that blank cells are shown as blank and not with a number or symbol in them ?
|