Catalog merge prints a '0' instead of my merged text

K

Kevin

When using Publisher 2007 catalog merge with an excel data source, some of my
merged fields print as 0 instead of the source text. My excel spreadsheet
column(s) are formatted as 'text'. The merging problem seems to occur when I
have numbers in the excel column, particularly if the excel cell contains
somethink like '10" to 20". I have tried using the single quote in excel
field to designate the entry as text with no success. Any ideas?
 
M

Mary Sauer

It seems to me you can format the field as text without the quote. I advise
folks that use zip codes that start with a zero to format the field as text. It
works for them. JoAnn Paules knows Excel, hopefully she'll be forthcoming with
advice.
 

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

Mail Merge Directory Conditional Page Break 0
Page numbering with Merged Document and IF statements 1
Data merge from Excel 2007 1
How to display the merge function "url" of a picture? 0
How to auto-scale images in catalog merge 0
Catalog Merge with MySql 3
Catalog Merge 1
Word macro that can call cells out of Excel for a find and replace 0

Top