Assign Zip Code Text For Free

'Zip-code' Is a Verb Both, Dictionary.com and Merriam-Webster list zip-code as a verb, and they keep it all lowercase and use a hyphen. It means to mark something with a ZIP code, as in "Be sure to zip-code that letter."

The standard zip code notation used by the United States Postal service uses five digits to identify a delivery area. An example of a standard US zip code is 90210.

Why Stores Want Your Zip Code Stores want your ZIP code because, combined with your name from your credit card, they can use it to find out other information about you from commercial databases, like your full mailing address. They may even sell the information to data brokers, who sell it to other marketers.

Click in a blank cell that is adjacent to the first number. As an example, see the image below. If E1 contains Zip and E2 to E9 have the actual zip codes, and your data stops in column G, you would click cell H2 and type =Text(E2,000002033) and press Enter.

Include leading characters in postal codesSelect the cell or range of cells that you want to format.On the Home tab, click the Dialog Box Launcher.In the Category box, click Custom.In the Type list, type 0 followed by the postal code format that you want to use.

Why Stores Want Your Zip Code Stores want your ZIP code because, combined with your name from your credit card, they can use it to find out other information about you from commercial databases, like your full mailing address. They may even sell the information to data brokers, who sell it to other marketers.

With a name and address, a thief can change your address via U.S. Postal Service and redirect mail to their address of choice, Velasquez says. With access to your financial mail, the thief may intercept bank statements and credit card offers or bills, then order new checks and credit cards.