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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

V-ger - 22 May 2007 17:04 GMT

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!

Reply to this Message

Doug Robbins - Word MVP - 22 May 2007 21:34 GMT

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.

Signature

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

> 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.,
[quoted text clipped - 11 lines]
> What should I do to them to make Word recognize these numbers, please?
> Thank you so much for your help!

Reply to this Message

V-ger - 22 May 2007 22:05 GMT

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

V-ger

> 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
[quoted text clipped - 16 lines]
> > What should I do to them to make Word recognize these numbers, please?
> > Thank you so much for your help!

Reply to this Message

Peter Jamieson - 23 May 2007 00:12 GMT

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

Peter Jamieson

> PERFECT! Thank you so much for your help today. It was the perfect
> solution
[quoted text clipped - 27 lines]
>> > What should I do to them to make Word recognize these numbers, please?
>> > Thank you so much for your help!

Reply to this Message

V-ger - 23 May 2007 15:07 GMT

Thank you.

> BTW, if you really want to know "why", there's an explanation of sorts at
> http://tips.pjmsn.me.uk/t0003.htm
[quoted text clipped - 31 lines]
> >> > What should I do to them to make Word recognize these numbers, please?
> >> > Thank you so much for your help!

Reply to this Message