Labels & Zip Codes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George N. Wells CPIM - 27 Nov 2003 12:42 GMT

I just made up a batch of labels using the embedded
wizzard in Word 2002. Importing the data from a
spreadsheet, I found that the program dropped the leading
zeros on the zip codes although the spreadsheet cells
were properly formatted and mapped.

Is somebody aware of this and working on it?

Reply to this Message

macropod - 28 Nov 2003 10:03 GMT

Hi,

If you select the offending field in your document and
press Shift-F9 to reveal it's code, you can correct this
by adding a numeric picture switch:
\# 00000
to the end of the field (but before any other switch (eg
\* mergeformat), if there is one).

Cheers

>-----Original Message-----
>I just made up a batch of labels using the embedded
[quoted text clipped - 5 lines]
>Is somebody aware of this and working on it?
>.

Reply to this Message

Joseph J. Greenberg - 13 Jan 2004 06:07 GMT

for some reason this is resulting in the literal "00000" in all my records
where the zip starts with a 0. any thoughts?

> Hi,
>
[quoted text clipped - 16 lines]
> >Is somebody aware of this and working on it?
> >.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 13 Jan 2004 06:27 GMT

Hi Joseph,

Follow the information from Peter Jamieson that was included in your earlier
post.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

> for some reason this is resulting in the literal "00000" in all my records
> where the zip starts with a 0. any thoughts?
[quoted text clipped - 19 lines]
>> >Is somebody aware of this and working on it?
>> >.

Reply to this Message