Number format : decimal and thousands separators

#1

Hi everyone,

I want to change the default separators for numbers.

  • A blank space for thousands : 1 200 instead of 1,200
  • A comma for decimals : 2,9 instead of 2.9

Is it possible?

Thanks a lot

#2

No reply in 5 days on this topic…

@JetTeam : is there anyone that can answer to this simple question?

#3

Hi,

You can use Javascript or Formula to implement the logic.

#4

I tried but it doesn’t work :

  1. (130000).toLocaleString(‘fr-FR’) = 130,000. => thousands separator remains a comma instead of a space in french
    image

  2. The issue is worst in tables and Kanban boards
    image

image
image439×556 32.8 KB

#5

I found the solution for tables !

image
image471×581 36.4 KB

#6

Thanks for the tip merkaljet !