Zip Codes beginning with zero and Excel

Factual Questions
1

I am creating an Excel 2000 list of address for relatives and friends to invite to my parents’ surprise 50th Wedding Anniversary party.

Several people live in New Jersey and their Zip Codes begin with a zero. If I format the zip code column as “Number” the zeros disappear. Apparently Microsoft and the USPS don’t agree on what a number is.

I searched Microsoft database and could only come up with this regarding Access but it seems to apply to Excel:

“Avoid storing postal codes in a Number field whose Format property is set to 00000. If you export the data to a text file, or if you include the postal code field in a Mail Merge in Microsoft Word, the Format property is ignored. As a result, any leading zeros in postal codes stored in a Number field are dropped”

http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010550691033&CTT=1&Origin=EC790000701033&QueryID=-c74q7Ejd&Query=zero&Scope=HP%2CHA%2CRC%2CFX

Well, darn it! I do want to “include the postal code field in a Mail Merge in Microsoft Word”! That’s why I’m doing this

I did a mail merge for the office Christmas cards labels the last two years but didn’t come across a New Jersey Zip Code.

Is the only solution to this to edit the zip codes in the Word mail merge before the labels are printed out? That’s the only thing I can think of. Does anyone have a solution?:confused:

2

I found the solution. Zip Codes are in the Special Category in the format menu. Thanks anyway.

Now I know what Gilda Radner’s “Emily Litella” felt like.:smiley:

3

Glad you found your answer. If this ever comes up with a non-Zip code situation you can also make the column “Text” format, which will allow you to enter numbers with a zero in front.

4

In case you’re typing something other than ZIP codes, “text” format solves the leading-zero problem. What you type is what you get.

5

You don’t say? :wink:

6

Another trick is the old “label” designation, copied from 1-2-3 (I think). In any field, precede anything you want to type with a single-quote (’). It will be treated as a label or text field. Good way to write formulae without treating them as formulae.

7

Ah forget about it ll and boot up the flight sim. :smiley:

8

You can also simply put a ’ in front of the zero.