Exporting to Excel shows different data notations.
We prefer 'DD-MM-YYYY' but how can we arrange this? It happens with all date-fields from Dynamics.
*This post is locked for comments
I checked the link, and I understand the situation in Excel. But it doesn't solve my problem.
I have found something new. When I export to:
- Open in Excel Online: no problem with the format
- Static worksheet: no problem with the format
- Dynamic worksheet: no problem with the format
- Dynamic pivottable: two different formats
What is different in a pivottable?
How can I open a support ticket for Microsoft? Impossible to find??
1. Change the format of the row in Excel itself.
>> nothing happens
2. Was the data entered this way to start off with?
>> In CRM Online the data is showed correctly. It happens when we export the data.
3. Have you checked personal and global format and date settings?
>> I think we have checked all the settings, but maybe there are more places?
1. Change the format of the row in Excel itself.
2. Was the data entered this way to start off with?
3. Have you checked personal and global format and date settings?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (