Operate Zip Code Text For Free

Use the Format Cells option to convert number to text in Excel Select the range with the numeric values you want to format as text. Right click on them and pick the Format Cells? option from the menu list. Tip. ... On the Format Cells window select Text under the Number tab and click OK.

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.

If you want to improve the chances that the letter will make it to its destination quickly, you should use the five-digit ZIP code plus the four additional numbers that are specific to the area. To format, write the ZIP code with a hyphen afterward and then the four additional numbers will immediately follow that.

If prompted for your ZIP code, just enter the three digits of your postal code plus two zeros. So for example, if your postal code is A2B 3C4, the 5-digit number you should enter is 23400. Contact your card issuer if you have any questions.

India does not have a 5 digit zip code. Instead, it has a 6-digit PIN Code - Postal Index Number(PIN). You can find further details about PIN in the following answer.

The term Postal Index Number (PIN) is popularly known as PIN Code/Postal Code in India. It is a code in the post office number of the postal code system which is used in India Post for segregating the mails. The PIN code consists of six digits.

Addresses consist of: The recipient's first and last name. Street number and name (address line 1) Apartment or unit and its number (address line 2) City, state and zip code (include all of this on one line with a comma between city and state, but not zip code) Country.