Zip Code import error

P

Phillybanker

When I import contacts from an excel file (csv or xls), the zip code number
is imported with a decimal point and three trailing zeroes. eg. 19004 becomes
19004.000. Is there a way to a) avoid this problem in the first place, and
b) efficiently change the zip code in a contact once imported instead of
clicking and editing the zip code field in each contact one by one?
 
Top