web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

BC14 french regional setting for decimal separator

(0) ShareShare
ReportReport
Posted on by 10

hi, 

my local is in french, and when i write some decimals with the numpad of the keyboard, the dot is not accepted. I have to write a comma.

how to change that ?

I have the same question (0)
  • Suggested answer
    Microsoft Dynamics 365 Business Central Profile Picture
    on at

    Hi,

    this is by design because this is a missing feature and the workaround for the customer is simply to use the comma character instead of the numeric pad separator.

    also please go to  aka.ms/bcideas, where you can vote for this idea to be prioritized.

    See here:

    Microsoft Idea Â· Decimals in webclient - (Numeric Keyboard not following US formatting rules) (dynamics.com)

  • Community Member Profile Picture
    on at

    Hi,

    You can achieve this by below ways:

    Store data with dot(.) as decimal separator in database and at the time of retrieval you can convert the value into string and replace dot(.) with comma(,). For example,

    string doubleValue=valueFromDatabase.ToString("0.00");
    doubleValue=doubleValue.replace('.',',');


    You can also use the varchar format. so you can store data with a comma(,) as decimal separator and retrieve directly from database. You can provide client side validations for accepting data in the required format.

    French language classes in Pune

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans