Excel field does not show up as entered when doing mail merge

[ixratee]

Using Office 2002. Data in Excel field is a number, a dash, and a letter, ie:4509-C. When merged for labels the data does not show up. A "0" appears. I have formatted the Excel field as General, Number, and Text with the same results. Also, when a field is blank, the "0" appears in the Word document field. I've never had this problem before.

 

[Beau]

Not an answer but to confirm similar problems in 2003.
When I try to merge numbers into a Word mail merge doc.
the numbers will add several decimals. I have tried
pasting values into Excel and the round function with no
luck. What I do, which works, is copy and paste the
worksheet to a word doc which dumps the data into a table
then merge the Word table to the Word mail merge main
doc. It's an extra step but it gets the results.

-----Original Message-----
Using Office 2002. Data in Excel field is a number, a

dash, and a letter, ie:4509-C. When merged for labels
the data does not show up. A "0" appears. I have
formatted the Excel field as General, Number, and Text
with the same results. Also, when a field is blank,
the "0" appears in the Word document field. I've never
had this problem before.

 

[Beau]

See Empty cell in Excel for a possible answer.

-----Original Message-----
Using Office 2002. Data in Excel field is a number, a

dash, and a letter, ie:4509-C. When merged for labels
the data does not show up. A "0" appears. I have
formatted the Excel field as General, Number, and Text
with the same results. Also, when a field is blank,
the "0" appears in the Word document field. I've never
had this problem before.