Friday, August 31, 2012
Add Leading Zero's to Zip Codes in Excel
Two methods to pad zip codes with 0's when they are less than 5 digits:
This changes the value of the cell:
This doesn't change the value of the cell but simply displays the number with the leading zeros:
2. Within the cell (or highlight the column) select Format > Format Cells, Number, Custom, 0000#
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.