Hold on to your seats, this is going to be a bumpy ride...

I have Excel 2003 set up as a database where certain values are derived
from vlookups. This works fine and returns the correct values in the
spreadsheet. I then use the Excel spreadsheet as a database for a mail
merge in Word 2003. The problem is, of the 4 values that are produced
from the vlookup, one of them is returning a "0" value in the mail
merge, even though that's not what is appearing in the spreadsheet.

I've checked the spreadsheet to be sure all cells are fomatted
correctly - I can't find what is causing this! Can anyone help me? It
will take hours of work to recreate this spreadsheet and I would prefer
to fix the issue rather than start from scratch!


--
Furniture1st

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx



Furniture1st wrote:
Hold on to your seats, this is going to be a bumpy ride...

I have Excel 2003 set up as a database where certain values are derived
from vlookups. This works fine and returns the correct values in the
spreadsheet. I then use the Excel spreadsheet as a database for a mail
merge in Word 2003. The problem is, of the 4 values that are produced
from the vlookup, one of them is returning a "0" value in the mail
merge, even though that's not what is appearing in the spreadsheet.

I've checked the spreadsheet to be sure all cells are fomatted
correctly - I can't find what is causing this! Can anyone help me? It
will take hours of work to recreate this spreadsheet and I would prefer
to fix the issue rather than start from scratch!




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html