Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Problem with decimal separators

Posted on by Microsoft Employee

Hi everyone,

I'm facing a problem with CRM 2016.

When I export a dynamic excel table with currency, it appears in Spanish format ( "," for decimals, and "." for miles)

but when I click on "Refresh from CRM" it suddenly changes to "." for decimals. This is a problem for my CEO so I need to fix it.

Currency format in CRM is set to Spanish correctly.

What it can be?

Thank you

Regards

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Problem with decimal separators

    Hi, thank you!

    The problem is I have the same problem and changing delimitators form excel doesn´t solve the problem.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Problem with decimal separators

    Hi!
     
    It seems like your CEO has to change his personal settings for decimals delimiter:

    Hope it helps.
     
    Please mark it As Answered or Verified if it did help you.

    Thanks

    Vlad
    dynamicalabs.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans