Why does Publisher substitute zeros for text when merging w/Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

No matter how I format the cells (number, general, text) it keeps putting a 0
in wherever I have anything but a single number. Specifically, I'm trying to
print a label in Publisher ('03) using mail merge, with the data source being
an Excel table. Some of the cells in the data source contain two numbers (4
& 6, typed just like that). In Excel it shows up the way I want it, but when
I use mail merge it converts these cells to 0. How do I get it to stop doing
this?
 
This newsgroup is for questions about Access, the database product that's
part of Office Professional.

Your question would be best reposted to a newsgroup that's related to
Publisher, or, perhaps, one for Excel.
 
Back
Top