How do I format a Canadian zip code in Excel?

How do you format a 5 digit zip code in Excel?

Microsoft Excel

While keeping your cursor inside the column, right-click it and choose “Format Cells”. Then the Format Cells window will pop up and stay in the “Number” tab. Look for “Special”. Then make sure that within “Special”, “Zip Code” is selected.

How do you correctly format a postal code?

Postcodes should always be in BLOCK CAPITALS as the last line of an address. Do not underline the postcode or use any punctuation. Leave a clear space of one character between the two parts of the postcode and do not join the characters in any way.

How do I fix my zip code in Excel?

Apply a predefined postal code format to numbers

  1. Select the cell or range of cells that you want to format.
  2. On the Home tab, under Number, on the Number Format pop-up menu. , click Custom.
  3. In the Format Cells dialog box, under Category, click Special.
  4. In the Type list, click Zip Code or Zip Code + 4.

How do I get rid of zip 4 in Excel?

At this point you have the first five digits of the ZIP Code in the original column and the last four digits (if any) in the previously empty column to the right. You can delete the column containing the four digits, if desired. All you need to do is select the cells containing the ZIP Codes, and then run the macro.

IT\'S FUNNING:  Does the Bank of Canada Act as a bankers bank?

What is 9999 format for zip code?

The 4-digits refer to a grouping of delivery points either geographic (a city block, a building) or a specific destination in the case of a high volume mail recipient. It is common to use -9998 for mail addressed to the postmaster, 9999 for general delivery.