"0" value merged

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cb - 13 Jan 2004 14:29 GMT

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. thanks for your help.

Reply to this Message

Cindy M -WordMVP- - 14 Jan 2004 19:57 GMT

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

:-)

Reply to this Message