Forum Discussion

Randy's avatar
Randy
Advocate I
10 years ago
Solved

Localization numeric formatting (periods and commas)

In the Netherlands, as well as a lot of other countries, we use commas to indicate the decimal place. We also use periods to seperate thousands, but only for currencies.   I have a PowerPivot datas...
Need Help
  • Tishchenko's avatar
    Tishchenko
    10 years ago

    this bug was fixed in build 11.0.9169.163 (23-dec-2015)

     

    Thanks!!!

Spotto's avatar
Spotto
Helper IV
10 years ago

 

My version is 13 and continues with this bug any tips ?

 

 

Rantonucci's avatar
Rantonucci
Regular Visitor
8 years ago

Hey Guys, 

When I use the Format Function, commas are replaced by dots (Regional Settings already set for Chile).

For Instead:

Measure = Format(Calculate(sum(xx), Filters...), "#,##0;(#,##0)")

If I take out the format function numbers appear with a dot  for thousands, on the contrary, i get commas. 

Please have you got any solution for this problem?

Best