web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Currency field is bein...

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

Currency field is being exported to excel as text field....why?

(0) Share

Report

Report

Posted on by USA80

26

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?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Nya 29,064 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

#2

André Arnaud de Cal... 74 Super User 2026 Season 1

#3

Martin Dráb 56 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans