1. Change the export format to Text
  2. Export the file again
  3. Open Excel
  4. Browse to and open the TXT file exported in step 1
  5. In the Wizard, choose to format the Constituent ID column as Text instead of General
  6. Finish the Wizard
  7. Save the file in Excel or CSV format