Merge field displays 0

[Serendipity]

Using Word 2003. Using Excel as my data source. In Excel the "Quantity" field
is formatted as "text" because it may have a value of 23 or 1 bag. When I do
the Word merge, the fields that have any alphabetic characters in them
display a 0. What is going on? Thanks for your help!
Marie

 

[Peter Jamieson]

The simplest workaround is to check Word Tools|Options|General|"Confirm
conversion at open", then go through the process of connecting to your data
source again and select the DDE option when it is eventually offered. Your
sheet will need to be the first in the workbook or the one previously opened
in Excel.

In essence, the problem results from the fact that the Jet OLEDB provider
that Word 2003 uses by default to get data from Excel tries to determine a
data type for each coloumn, looking at the first 25 rows in the column. If
the column has more than one data type, the provider is likely to use the
"majority" type - if it decides that's "numeric", text values will be set to
0.

Peter Jamieson