Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Display Numbers As Postal Codes. Show negative numbers in parenthesis. ZIP Code - The Basics - USPS.
1 from encrypted-tbn0.gstatic.com
For example you can use zeros or dashes to display a postal code as follows. India uses a unique six-digit code as a geographical number to identify locations in India. On the Home tab click the Dialog Box Launcher next to Number.
The basic 5-digit format was first introduced in 1963 and later extended to add an additional 4 digits after a dash to form a ZIP4 code.
To display numbers in Scientific Notation format Exponential format include the capital letter E in your number format code. As a UK resident who has had to deal with American sites including the Dell support site that requires you to put in a zip code the Zip codes are numbers thing is a BAD mistake to make. You can format a cell or range of cells to display leading characters so that the postal code is preceded by enough characters to fill the cells width. Postal codes are known as Postal Index Numbers PINs.