When exporting records from a table with one or more currency fields to Excel, the currency fields are in text format, so Excel cannot perform calculations. XML and CSV show only numeric values.
Steps to Reproduce
- Create a table with a Currency field.
- Fill in some records.
- Export to Excel.
Notice that the column format is text and no calculations are possible.
Export to CSV and open in Excel or change the column format in Excel.
Related Problem: PRB617796