Zero Missing in Zip Code When Exporting to Excel

When exporting a file from Demandbase One for Sales to Excel, you may notice that the 0 is missing in zip codes that start with that digit. For instance, if the zip code is 06902 the exported result appears with a truncated zero - 6902. It is a standard default in Excel, and can easily be fixed.

1. Export the CSV file and save it to your hard drive without opening it. Open a new blank Excel spreadsheet.
2. Click Get External Data - From Text. 
   
3. Select and import the data.csv file.
4. In Text Import Wizard - Step 1 of 3, select the following options, and click Next. 
   
5. In Text Import Wizard - Step 2 of 3, select Tab and Comma as delimiters and click Next.
6. In Text Import Wizard - Step 3 of 3, select Text as Column data format. 
7. In Data Preview, select the Postal Code column.
   
8. Click OK. The excel sheet displays the entire zip code without truncating the 0s.