Hi,
Locale settings for data table is “German (Germany)”
Decimal value is 1.919,3
TEXT(decimal value) = 1,919.3
How can I change this, that TEXT() is working correctly?
@Steve what I am doing wrong? Thank you, Joachim
Hi! It’s been a long time since your post. Sorry no one responded. Is your situation resolved?
The TEXT() expression is an AppSheet expression so I don’t think the format setting for your table will change it. I think you could combine expressions with CONCATENATE() to get what you want in AppSheet. Are you still interested?
2 Likes
Thank you @Kirk_Masden , the problem I described is a bug in AppSheet.
I did a workaround with three substitute() 
, not very comfortable
1 Like
AFAIK, Text() doesn’t take into account locale.
For example, when working with dates, TEXT(TODAY(), “DD-MMMM-YYYY”) will be 06-MARCH-2022
2 Likes
Try:
"" & [decimal]
2 Likes
What does this means?
It’s an expression to try instead of TEXT( [decimal )
Also, I literally just gave this exact same answer in another question, what a coincidence!
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/TEXT-doesn-t-remove-comma/td-p/401018
4 Likes
The TEXT() function uses the locale of the device, not that of the spreadsheet.
thank you @Steve but my chromebook and my windows notebook are both set to german.
What I am doing wrong?
Idk if that’s what it does or what it should.
I remember we talked about this before.
In my case TEXT() always works as if I where on the US
seems the same to me