Build Zip Code Text For Free

Select the cell or range of cells that you want to format. , click the arrow, and then click More Number Formats. In the Format Cells dialog box, under Category, click Special. In the Type list, click Zip Code or Zip Code + 4.

Once you finish arranging your data, select the cells you want to turn into the map. Then on the Insert tab, go to Charts > Maps > Filled Map. Here Excel reads the ZIP codes you entered and creates a map chart based on them.

ZIP Codes are numbered with the first digit representing a certain group of U.S. states, the second and third digits together representing a region in that group (or perhaps a large city) and the fourth and fifth digits representing a group of delivery addresses within that region.

A. ZIP code data changes frequently. Every year there are thousands of changes to the USPS ZIP Code records.ZIP codes are created or discontinued.

Display numbers as postal codesSelect 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.

Shorten to five digits from Zip+4 format. Make a map based on a list of addresses or zip codes....Shorten to Five DigitsInsert 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.

You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes.