zip codes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon - 08 Mar 2004 15:05 GMT

When I try to merge from an excel spreadsheet the zip
codes are missing the first number example 01801 comes
out 1801. Excel is formated for zip codes, I've also
tried formatting it for text, number, etc. How can I make
the whole zip print.

Reply to this Message

Graham Mayor - 08 Mar 2004 16:46 GMT

See http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> When I try to merge from an excel spreadsheet the zip
> codes are missing the first number example 01801 comes
> out 1801. Excel is formated for zip codes, I've also
> tried formatting it for text, number, etc. How can I make
> the whole zip print.

Reply to this Message

- 10 Mar 2004 14:41 GMT

Hey Graham, I have used your site, and it does work. The
problem is it is way too cumbersome for one of my
executive team to do every time they have to do a merge.
Is there a "fix" for this that is a bit more permanent?

>-----Original Message-----
>See http://www.gmayor.com/formatting_word_fields.htm
[quoted text clipped - 6 lines]
>
>.

Reply to this Message

Graham Mayor - 10 Mar 2004 15:05 GMT

There is nothing cumbersome about using a field mask - If your 'executive'
team can't respond to a touch of training, they are being paid too much. The
only other option is to change the way Word connects to the data file -
linked from the same page - but this is even more complex.

Signature

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

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

> Hey Graham, I have used your site, and it does work. The
> problem is it is way too cumbersome for one of my
[quoted text clipped - 18 lines]
>>
>> .

Reply to this Message