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:
1. =TEXT(A1,"00000")

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#

Creative Commons License 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

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...