Video: How To Get Rid Of Zeros

Working with ZIP Code data in Excel or some other spreadsheet application. For the most part,  is very straight forward, just open the file and work with the ZIP Codes.

However, the same spreadsheet application that makes it possible to work with ZIP Codes, also makes it difficult because it will attempt to interpret the numbers into a format that the program likes. This isn't always helpful. Many ZIP Codes begin with a zero, and Excel will drop that zero from the ZIP Code, making your job harder.

This Zip Code Download video will show two very easy ways to correct the problem.