Details
-
Type: Improvement
-
Status: Open
-
Priority: Minor
-
Resolution: Unresolved
-
Affects Version/s: 4.6.15
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
When creating a CSV export from a contact search, (US) zip codes (and +4) beginning with a 0 are not enclosed in "". As a result, when they are imported in Excel or Google sheets, they are not treated as text, imported as numbers, and the leading 0 is lost. Excel does have the ability to define the format of each imported column IF the File->Import feature is used, but on a Mac, in the latest Excel, you can't scroll to the right when setting the format for each column, meaning that if the zip code column is column #10, you can't select it to set its format. That is a bug in Excel, but I do think we should fix this in CiviCRM as well, so that imports work "out of the box" and don't require file->import to import zip codes correctly.