Formatting Zip Code and Date / Time fields for importing into Salesforce
When importing data into Salesforce, it's important to have number fields formatted correctly. Imports will actually fail, if Date fields are not formatted properly. The two types of fields to watch out for are Zip Codes and Date / Times. When you open a csv using Microsoft Excel, Excel will apply a default formatting to these fields that is incorrect. Here is how you can avoid errors.