Assign Zip Code Text For Free

The correct format for a numeric ZIP+4 code is five digits, a hyphen, and four digits. The first five digits represent the 5-digit ZIP Code; the sixth and seventh digits (the first two after the hyphen) identify an area known as a sector; the eighth and ninth digits identify a smaller area known as a segment.

A 9-Digit ZIP code, also known as a ZIP+4 code or an extended ZIP code, includes the same information as the 5-Digit ZIP code, plus additional information about a specific delivery route within the delivery area.

Follow the steps below to shorten to five digits: Insert a new column to the right of your current zip code column. Type or copy and paste =LEFT(C2,5) , replacing C2 with your cell's identifier. Drag the formula down the rest of your column.

A ZIP Code is a 5-digit number that specifies an individual destination post office or mail delivery area.

Display numbers as postal codes Select the cell or range of cells that you want to format. To cancel a selection of cells, click any cell on the worksheet. On the Home tab, click the Dialog Box Launcher. next to Number. In the Category box, click Special. In the Type list, click Zip Code or Zip Code + 4.

A 5-Digit ZIP code represents a USPS delivery area. A 9-Digit ZIP code, also known as a ZIP+4 code or an extended ZIP code, includes the same information as the 5-Digit ZIP code, plus additional information about a specific delivery route within the delivery area.

Yes, when using a ZIP+4 ZIP Code, the number must consist of five digits, a hyphen (or dash), and four digits. Improperly labeled mailpieces may progress slower through the mail system and may be returned to sender if the United States Postal Service® is unable to deliver the item.

(Making you key it in serves as an added security measure to foil a thief who doesn't know the numbers.) But it's usually unnecessary at brick-and-mortar stores, so just say no. And your ZIP code certainly shouldn't be posted on social media or other public websites.

Disclosing ZIP codes allows "people to track their purchases. It creates a profile and that information can be shared with other companies and that's dangerous to have that information in one area," says lawyer Gene J. Stonebarger, whose lawsuit triggered the ruling.

Alone, your ZIP code might not be of much value all by itself, but criminals will take that information and post it on underground sites where they buy, sell and trade bunches of personal information. From those sites, criminals can purchase enough of your personal information to use it for fraud.