I’m afraid I don’t get what you’re saying. I don’t know near as much as
I would like to and I’m sure not a fraction of what you do .. this is
kicking my butt!! ):
Apparently my formulas do not recognize the values from the columns
using the text function either.
A little more info:
I have 39 columns of information (1800 rows so far) either entered or
pulled in by formulas that could be any combination of text and
numbers. I use as many formulas as I possibly can to pull in info from
other spreadsheets to save time. -I do copy/paste values over all rows
completed so I only have a minimal number of rows with formulas. I
pretty much depend on mail merge to bring everything together. Reports,
credits, packing slips, shipping docs, pull logs, labels. ugh!
I am the only one (so far) upgraded to Office 2003 .. it looks like I
may have to go back to 2000 if I cant figure this out. Our IT dept. has
determined it is not a network issue (they did all updates & suggestions
Microsoft offered). I mention that because my spreadsheet was on the
network, they moved some stuff around & the DDE thing quit working
(coincidence?) so I saved it to my desktop – worked fine for awhile,
then quit again. I have gotten at least on engine failure message when
trying to connect to my data source .. “This operation cannot be
completed because of dialog or database engine failures” .. blablabla.
Too much info? Sorry. Don’t want to waste your time, perhaps you could
suggest mail merge reading material? – I obviously need to study but am
definitely willing to try any suggestions – if you could use little
words |:
Thanks again!
That's why we have some forums that are topic-specific :-) Mail merge
is a
very specialized area...
You have two choices
1. Copy the problem column VALUES to another column.
2. Use the TEXT function ("around" the current formula) to explicitly
format the result as text. In my experience, Word respects that.
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 :-)