Zip code formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M_RMurray - 06 Oct 2004 21:17 GMT

I have an excel spreadsheet with a formatted zipcode field. Many -- but not
all -- of my zip codes start with a first character of "0". When I merge
them into labels in Word, the "0" is no longer visible. How can I correct
this problem so the first character "0" appears on the labels?

Reply to this Message

Barb R. - 06 Oct 2004 21:31 GMT

Do a search for ZIP in the Word Mailmerge and Fax Discussion group. I saw
an answer to this recently on this board.

Barb R

> I have an excel spreadsheet with a formatted zipcode field. Many -- but not
> all -- of my zip codes start with a first character of "0". When I merge
> them into labels in Word, the "0" is no longer visible. How can I correct
> this problem so the first character "0" appears on the labels?

Reply to this Message

Doug Robbins - 07 Oct 2004 01:34 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have an excel spreadsheet with a formatted zipcode field. Many -- but
>not
> all -- of my zip codes start with a first character of "0". When I merge
> them into labels in Word, the "0" is no longer visible. How can I correct
> this problem so the first character "0" appears on the labels?

Reply to this Message

Rate this thread: