American FactFinder: How do I replace the leading zeros in my database compatible (.csv) download when opening the download in Microsoft Excel (that is, GEO ID2)?
Database compatible format (.csv) downloads sometimes include geographic codes such as the GEO ID2 code, or FIPS codes in the G001 downloads. When the download is imported into certain external programs, such as Microsoft Excel, leading zeros will be omitted by default, for instance for IDs that contain a two-digit number from 01 through 09. In Microsoft Excel, the leading zeros can be replaced as follows:
Verify the number format code you want displayed is correct by looking at the format code sample box located just above the “Type:” textbox. Make any changes to the number format code until the sample that is displayed is the correct format.
Click OK and the highlighted cells will update with the new number format code.