Avoid exporting a roster report without dropping leading zeros
Roster export dropping leading zeros in the zip codes? That is *not* a bug with Tendenci but, in fact, a default setting in Excel when opening a new worksheet. The work around:
- Run a roster export
- Save it to your local drive (opening the file at this point will drop leading zeros
- Launch the Excel application
- On the menu go to "Data > Import External Data > Import Data
- Browse to the file on your local PC and open
- Choose Original data type radio button "Delimited" then next
- For Delimiters select "Tab" and "Comma" then next
- Select the column to define the data type (in this case we will select the "Zipcode" column and specify the data format to be "text"
NOTE: you will have to scroll over to see all the columns - Then click "Finish"
- Keep the default setting of "Existing Worksheet" and click OK.