The current postal code (postal codes) range of the United States (US) is: 00001 – 99950.
#Us zip code list excel how to#
In the Type box, type 00000 00000-0000įor more information about how to create custom number formats, see Create or delete a custom number format. For example, if a range of cells contains both five-digit and nine-digit postal codes (ZIP Codes), you can apply a custom format that displays both types of ZIP Codes correctly. In the Type box, make the necessary changes to the selected number format. The original number format in the Type list cannot be changed or deleted, so don't worry about overwriting the original number format. When you select a built-in number format in the Type list, Excel creates a copy of that number format that you can customize. The number format that you select appears in the Type box above the Type list.įor example, to customize the predefined Zip Code + 4 format, select 00000-0000 in the Type list. In the Type list, select the number format that you want to customize. On the Home tab, click the Dialog Box Launcher next to Number. mailing address with zip code + four, phone and fax numbers, taxpayer.
To cancel a selection of cells, click any cell on the worksheet. VSOF includes a Microsoft Excel add - in which enables users to develop full. Select the cell or range of cells that you want to format. Click Finish to finish importing your data. To solve this problem, in step 3 of the Text Import Wizard, click the column containing postal codes, and then, under Column data format, click Text. That's because Excel interprets the column of postal code values as numbers, when what you really need is for them to be stored and formatted as text. If you're importing addresses from an external file, you may notice that the leading zeros in postal codes disappear. Different locales provide different or no special codes in the Type list. These codes are available in the Type list only if the Locale (location) is set to English (United States).