Help! Word reading fields merged from Excel as "0"s instead of da V-ger 5/22/2007 4:04:00 PM 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!

Re: Help! Word reading fields merged from Excel as "0"s instead of da "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/22/2007 8:34:44 PM 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" <Vger[ at ]discussions.microsoft.com> wrote in message news:BBDE0F40-4C25-4E8F-9199-D59B13CEE0B3[ at ]microsoft.com... [Quoted Text] > 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!

Re: Help! Word reading fields merged from Excel as "0"s instead o V-ger 5/22/2007 9:05:00 PM PERFECT! Thank you so much for your help today. It was the perfect solution to my issue. V-ger "Doug Robbins - Word MVP" wrote: [Quoted Text] > 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" <Vger[ at ]discussions.microsoft.com> wrote in message > news:BBDE0F40-4C25-4E8F-9199-D59B13CEE0B3[ at ]microsoft.com... > > 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! > > >

Re: Help! Word reading fields merged from Excel as "0"s instead o "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/22/2007 11:12:55 PM 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" <Vger[ at ]discussions.microsoft.com> wrote in message news:B2F0E0FC-39EE-463D-B0F6-42F3C45F5879[ at ]microsoft.com... [Quoted Text] > PERFECT! Thank you so much for your help today. It was the perfect > solution > to my issue. > > V-ger > > "Doug Robbins - Word MVP" wrote: > >> 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" <Vger[ at ]discussions.microsoft.com> wrote in message >> news:BBDE0F40-4C25-4E8F-9199-D59B13CEE0B3[ at ]microsoft.com... >> > 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! >> >> >>

Re: Help! Word reading fields merged from Excel as "0"s instead o V-ger 5/23/2007 2:07:01 PM Thank you. "Peter Jamieson" wrote: [Quoted Text] > 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" <Vger[ at ]discussions.microsoft.com> wrote in message > news:B2F0E0FC-39EE-463D-B0F6-42F3C45F5879[ at ]microsoft.com... > > PERFECT! Thank you so much for your help today. It was the perfect > > solution > > to my issue. > > > > V-ger > > > > "Doug Robbins - Word MVP" wrote: > > > >> 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" <Vger[ at ]discussions.microsoft.com> wrote in message > >> news:BBDE0F40-4C25-4E8F-9199-D59B13CEE0B3[ at ]microsoft.com... > >> > 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! > >> > >> > >> >