Data column has a mix of text and numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

harg7769@lineone.net - 09 Apr 2004 10:31 GMT

I am trying to print labels using an excel spreadsheet as the data
source. One fo the fields is the House number. Some of the house
numbers also haver a flat position incorporated, eg 62a High Street.

When I try to merge the fields, the ones with a letter in them are
merging as 0. Is this because Word is assuming that the field should
be a number field like all the other records, and so automatically
assigns it a value of 0? If so, how do I fix it?

Regards

Andrew H

Reply to this Message

Graham Mayor - 09 Apr 2004 11:13 GMT

See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am trying to print labels using an excel spreadsheet as the data
> source. One fo the fields is the House number. Some of the house
[quoted text clipped - 8 lines]
>
> Andrew H

Reply to this Message

harg7769@lineone.net - 09 Apr 2004 12:37 GMT

Thanks Graham - perfect.

>See the Excel data section of
>http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Reply to this Message