How do I format a postal code in Excel?

How do I format a postal 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, next to General, in the Number Format box.
3. In the Format Cells dialog box, under Category, click Special.
4. In the Type list, click Zip Code or Zip Code + 4.

How many postal codes are there in South Africa?

3,044 Postal Codes in South Africa

What is the 5 digit Zip Code for South Africa?

We do not use ZIP codes in South Africa. We do have postal codes. Johannesburg comprises a vast area with many suburbs and areas all falling under various post offices.

How do I change the Zip Code to 5 digits in Excel?

Follow the steps below to shorten to five digits:

1. Insert a new column to the right of your current zip code column.
2. Type or copy and paste =LEFT(C2,5) , replacing C2 with your cell’s identifier.
3. Drag the formula down the rest of your column.

How do I write 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 are addresses written in South Africa?

Address format The last line (above the country name) always contains the postcode. The second last line contains locality or office name. The third last line contains the postal delivery point. The last three lines (above the country name) are formatted according to three standard address types.

What is the format of postal code?

The most complete ZIP Code is a nine-digit number consisting of five digits, a hyphen, and four digits, which the USPS describes by its trademark ZIP+4. The correct format for a numeric ZIP+4 code is five digits, a hyphen, and four digits.

What is South Africa state code?

Current codes