Hi Cb,
I am trying to merge a cell from excel 2002. the cell
contains both numbers and letters and is formatted
general. this cell produces a "0" value when merged into
word 2002. when the cell contains only numbers it merges
correctly.
This is a result of the connection method (which works over
the Excel ODBC driver) assigning a data type to the column
based on the first eight entries in the column. It will
decide something the column is numeric or text and suppress
entries that don't correspond.
Since the column should apparently be text, your best bet is
to tell Excel explicitly it should be text. You do this over
the Data/Text to Columns command. select the column, run the
command, and make sure to choose the "Text" option in Step 3
(you can just click through the other steps).
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
