Do one of the following:
  • Export the query in CSV or Excel format and open the file in Excel. Sort by the Assigned Number column (BB63566).

     

  • Update or enter constituent ID numbers with leading zeroes so that all have the same number of digits. For example:

    0000001

    0000002

    0000003

    and so on