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


  1. Create a table with a Currency field.
  2. Fill in some records.
  3. 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

Seen In

Berlin Patch 7
Calgary Patch 7 Hot Fix 5
Eureka Patch 11
Eureka Patch 6
Eureka Patch 7
Eureka Patch 7 Hot Fix 2
Eureka Patch 8
Fuji Patch 8
Geneva Patch 6

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-06-17 13:51:03