Note: As of July 9, 2018, Blackbaud’s School Management solutions (which include Core, onBoard, onCampus, onMessage, and onRecord) are utilizing a new top level navigation. This primarily affects users performing administrative tasks—constituent navigation for most parents, students, faculty, and alumni will remain the same. We appreciate your patience as we work to update our documentation. If you are seeing this message, the content of this solution is still being vetted for possible updates. Please refer to this mapping document if you need assistance finding a task in the new navigation.
When I export to Excel from an Advanced List, the Zeros are not displaying such as for Zip Codes. This is causing an issue with the Data being Exported as Zeros are being left out.
To fix this, you can update the format of the affected columns in Excel with these steps:
1. Highlight the column 2. Right-click the column and select Format Cells 3. On the Number tab, select Special 4. Select Zip Code as the Type 5. Click OK.