Question: are zip codes always 5 digits?
Answer:  U.S. ZIP Codes are always five digits long. These 3 and 4 digit numbers actually begin with one or two zeros. For example, when you see "501" for Holtsville, it's really 00501. As a default, Excel converts this column into a number and removes the leading zeros.