Help! Word reading fields merged from Excel as "0"s instead of da

[V-ger]

When I am merging in Word (03) using excel data...everything merges fine
except for one column where I have dashes in the excel numbers (e.g., 34-D,
etc.) Some numbers are single numbers in that column and some have dashes,
they are from singe to quadruple digits. When I merge them to my WORD doc,
the numbers with dashes all come out as ZEROs. Why will Word not recognize
these numbers? (I have tried changing them in Excel to Numbers, to Text, to
Scientific, to General, but Word still cannot read them.)

What should I do to them to make Word recognize these numbers, please?
Thank you so much for your help!

 

[Doug Robbins - Word MVP]

In Word in Tools>Options>General, check the box against "Confirm conversions
at open" and then reconnect the mail merge main document to the data source
and when asked for the method by which the connection should be made, select
the DDE option.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[V-ger]

PERFECT! Thank you so much for your help today. It was the perfect solution
to my issue.

V-ger

 

[Peter Jamieson]

BTW, if you really want to know "why", there's an explanation of sorts at
http://tips.pjmsn.me.uk/t0003.htm

Peter Jamieson

 

[V-ger]

Thank you.

BTW, if you really want to know "why", there's an explanation of sorts at
http://tips.pjmsn.me.uk/t0003.htm

Peter Jamieson