Number Formatting switching to Custom after saving report
SummaryI have a report that keeps formatting numbers as text when exporting to excel document, despite setting formatting in report
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.