Report Design - Export To Excel converts numbers as Text
I'm in report designer and I've built a behaviour report that exports the data to excel.
The only issue is that the numeric data (attendance percentages, count of number of incidents for the student) exports as text.
Excel gives me a warning exclamation mark / shreik saying that the number in the cell is formatted as text or is preceded by an apostrophe.
I can correct the columns when in excel, but if someboody else is running the report from the SLT, then I don't expect them to have to start formatting cells, especially if the want to do analysis on the counts e.g. pivot tables
Any ideas how I can force the report design to output the fields as numbers rather than text?