The Raiser's Edge imports the values as they appear in the data file. If the data file is opened in Excel (or other program), ensure the leading zeros are not dropped. If they have been dropped:
    • Close the file without saving it
    • Open the file in Notepad and check for the leading zeros. If they are still missing, use your original file that contains the leading zeros. If that is not available, manually add the leading zeros in Notepad and use this file in the import.


      To prevent this from happening in the future, either:
      • Refrain from opening the data file in Excel