MS Word Directory merge with excel spreadsheet

C

Carolyn Daugherty

We are merging an excel spreadsheet to a directory form in
Word and one of the columns changes to numeric when
connected. The column is formatted general in excel, some
of the records have numbers like "123" and other have
combos like "123 MM". When connected to excel I can see
that the records with "123 MM" have been changed to "0".
I have tried formatting the field in word to text, but I
still get the zero's when connecting to the datbase.
 
P

Peter Jamieson

Try formatting the entire column in Excel as text and reconnecting from
Word.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top