Merge-replaces empty field with 0 in merged doc

I

itdeptgeu

I have an excel data source. some fields are blank. when merging with word
main doc, the empty fields now have a value of zero (0) in the merged doc.
Other empty fields are ok, but just certain columns. have tried changing
column formatting to text only or general. tried stripping to text only file
and reimporting into excel - nothing works. anyone experiencing same or have
solution. tks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Mail Merge Directory Conditional Page Break 0
Page numbering with Merged Document and IF statements 1
Mail Merge and Underline 1
Email Mail Merge via linked Excel sheet 0
Word macro that can call cells out of Excel for a find and replace 0
Supress blank fields in merged doc 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top