When importing Zip Codes into Salesforce because the file must be in CSV format you can run into problems you didnt know were there. For example when you open up a data file in CSV format if there are any Zip codes with leading zeroes like 01752 they will appear with the leading zero chopped off and will display like 1752.
You can follow these steps below to be sure to load those leading zeroes.
1. Select the entire Zip Code column from within Excel.
2. Select the menu option Format -> Cells...
3. Select the Number tab, and click on the category called "Special".
4. You can then select the type Zip Code or Zip Code + 4, and then click OK.
Be sure to save the changes to your .CSV file.
NOTE: If you reopen the saved .CSV file in Excel, the formatting is not preserved. Opening in Notepad preserves the formatting. Save the formatting of the zip code for your last step when importing records. If you do not reopen the .CSV file in Excel before importing, the zip codes are imported with the appropriate leading zeroes.
These steps came from the Salesforce custom community:
https://success.salesforce.com/questionDetail?qId=a1X30000000HZDMEA4
No comments:
Post a Comment