Reports do not have appropriate formatting when exported

When exporting a report from any area in Sphere (i.e. initiative reports, Payment Detail Reports, My Reports, Saved Reports, etc.) an organization may notice that their resulting Excel is formatted entirely as text and omits or mis-formats numerical data. As a result, you might be unable to use Arithmetic operations or Reports inside Excel.
 
Our team is currently evaluating this issue. In the interim, please complete one of the following steps: 
  1. The report can be exported as a .CSV file instead this will allow for the number to show as numbers in excel.
  2. The second option is to highlight the effected rows, the ones with the green arrows, and click the yellow icon and choose to convert to a number.
Converting in an Excel

Environment

 Blackbaud Sphere

Was this article helpful?