Number Formatting switching to Custom after saving report

Summary

I have a report that keeps formatting numbers as text when exporting to excel document, despite setting formatting in report

Content

Hi All,

I'm having an issue with a report that exports numbers as text to excel, even though I am setting a format to number, with no decimals.

The report uses expressions to count a requisition (1) if it is open, and then I use the summation function to add up the requisitions, giving a number (i.e. 14 open positions).

I've set the formatting to number, with zero decimal points, but when I export the report to excel, all the numbers show as "Number formatted as text". When I return to the report, the formatting shows as "Custom", rather than the number (with zero decimal points) that I set and saved it as.