Remove Commas in Number Format on Forms

Is there a way to change the number formatting inside appsheet. I select number in the drop down but it’s always putting the commas (example: 123,456,789) is there any way to just have it as 123456789

1 Like

@appteam6 you can turn off the thousands separator in your number column’s structure

2 Likes

How about the “Reports” function? I typed "<<YEAR(TODAY())>> in the google doc report, and it shows the comma. How do i remove the comma in a report?

The YEAR() function produces a Number result, and so is formatted using default Number formatting. You can force the result to Text and thereby bypass the Number formatting:

<<CONCATENATE(YEAR(TODAY()))>>

or:

<<(YEAR(TODAY()) & "")>>

See also:

2 Likes