Cindy M. Wrote:
Hi Rascl,
I am using office 2003, Word/Excel.
I am having trouble getting my text to display correctly in my merge
doc. The text displays as 0 but only values from 2 or 3 different
columns. The other text values (other columns) display correctly. I
am
very confused. I have played with the formatting in excel even though
I
understanding that word ignores that formatting (?) Previously I
found
that the “confirm conversion at open” solved my problem up until it
stopped working. That is to say, word will no longer stay connected
(?)
to my data source even though it does open my spreadsheet, it tells
me
it cannot find it & gives me the option of going to get it. If I
choose
to go get it from there I will continue to get the same results
(cannot
find the data source). Instead, upon opening my word doc., I have to
choose “no” do not connect to my data source and start from the
beginning each time.
I hope that was clear enough ..
I'm not sure I follow... "The text displays as 0 but only values from
2
or 3 different columns" can be interpreted in a couple of ways. You
mean
some columns pass a "0" instead of the content in the cell? Or do you
mean values from one column are appearing in the field for a different
column?
If you mean the first: do these columns have mixed text and numeric
entries? And the first few entries are numeric?
If that's the case, select one of the columns. Go to the DATA menu and
choose "Text to columns". The most important step is where you select
the
option that sets the data type. By default it's "General"; you want to
specifically say it's "Text". This will allow mixed text and numbers,
no
matter how you connect.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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 :-)
Ah! Cindy that’s awesome .. Except ): one of my columns contains
formulas to pull in data. It turns my formula into text so that it
doesn’t work – anyway around that one??
I appreciate your help!!! I have posted this before (other forum) but
you are the only one to reply. Thank you