it is very useful to export reports to excel but numeric and currency values get interpreted as textual values by default. Our development team is currently reviewing this issue in order to make it disappear. But until that happy day comes, here’s a work-around solution that addresses this nuisance in three easy steps.
Here’s a work-around solution to address this issue.
In the excel worksheet, select all the cells where numbers are being treated like text
Move your mouse pointer along the left edge of the selection area until you see a warning/fix icon
Click on the icon and select “Convert to Number”. All the selected numeric cells will be changed from text to numeric values in one click.
The step-by-step instructions start after the report has been exported to excel and the excel spreadsheet is open.