Thousands Separator

Hi Pierre,

The best way would probably to use a formula where you transform the number into a formatted text using the FORMAT function, as below :

format( Number, Format ) converts a Number into a formatted text. As Format a Text is needed:

0 represents a number or 0
# represents a number that is diplayed only, if the number is big enough
. represents the decimal separator (will be formatted according to the country, that means, in the UK and US it is shown as a floating point)
, represents the grouping separator (will be formatted according to the country,that means, in the UK and US it is shown as a comma)
Examples:

format(42.5, "0") results in "42"
format(42.5, "000") results in "042"
format(42.5, "000.00") results in "042.50"
format(42.5, "0.00") results in "42.50"
format(42.5, "#,##0.00") results in "42.50"
format(1042.5, "#,##0.00") results in "1,042.50"

It works for me:

1.  click this format

2. Then click Number Format box again and set the Digits to 0

3. The result is

Then, maybe is your system settings?

I know that Ninox doesn't have it's own control panel for Dates and follows Mac settings for desktop app and Browser settings for web app.

Maybe this applies for numbers too?

:-)