Now that you have AggData, what can you do with it? Welcome to the Resource Center, where you can find all the support and ideas that you need to take your data to the next level. We have simple-to-follow tutorials and how-to's so you can integrate and manipulate the data in many different applications and frameworks. We've only just launched this area of the site, so it may start out a bit sparse, but we'll be adding more and more in the near future, so keep checking back! If you would like to hear about our new resources, we will be featuring them in our AggData Newsletter each month. Sign up for our newsletter here!
Adding Zeroes Back to Zip Codes in Excel
Some zip codes in the United States are only four digits in length, or in the case of Puerto Rico and the Virgin Islands only three. In order to assure conformity, the US Postal Service adds one or two zeroes to the beginning of shorter zip codes, so that all zip codes are five digits in length.
Since Excel is a program that is mainly used for formula and math graphing, the zeroes at the beginning of the zip codes read as obsolete to the program, and are thus eliminated when saved as a CSV or Excel spreadsheet document.