So I have a report that shows records and has the field value that is configured as currency showing in the report. When I save the report as an excel file, and open it up in Excel, the currency value shows as a text field. Why is this?
So I have a report that shows records and has the field value that is configured as currency showing in the report. When I save the report as an excel file, and open it up in Excel, the currency value shows as a text field. Why is this?
Hi,
According to the following documentation, when the fields with Currency data format are exported into Excel, they will be shown as Number and does not include "$" symbol.
Cell format when data is exported from Customer Engagement (on-premises) to Excel
André Arnaud de Cal... 291,661 Super User 2024 Season 2
Martin Dráb 230,379 Most Valuable Professional
nmaenpaa 101,156