L
Lonnie
I'm having an issue with null values as well, but a bit different than Jean Paul's..
I'm running Office XPsp3. I have an Excel data source with blank cells in some phone number fields. (BTW - the fields are formatted as text, so no sneaky numbering formatting). When I open the data source in the Word merge document, I see zeroes in the empty cells. If I use the autofilter to select blanks only on that field, I get all the zeroes - so Word sees them as blank at least PART of the time. The problem is that when I run the merge I get zeroes in the places that should be blank, or if I use a formatting switch I just get the formatting. I've tested it in Office2k3 and don't have the problem. Any ideas
As an added twist - if I remove all data from the field, I get no zeroes. If I put data in JUST ONE CELL in the field, all the rest show the zero...hmmm
I'm running Office XPsp3. I have an Excel data source with blank cells in some phone number fields. (BTW - the fields are formatted as text, so no sneaky numbering formatting). When I open the data source in the Word merge document, I see zeroes in the empty cells. If I use the autofilter to select blanks only on that field, I get all the zeroes - so Word sees them as blank at least PART of the time. The problem is that when I run the merge I get zeroes in the places that should be blank, or if I use a formatting switch I just get the formatting. I've tested it in Office2k3 and don't have the problem. Any ideas
As an added twist - if I remove all data from the field, I get no zeroes. If I put data in JUST ONE CELL in the field, all the rest show the zero...hmmm