Text([number]) without thousand separators

AppSheet AppSheet Q&A
1

Hello friends. I have the following field

TEXT(YEAR([Date]))

This returns me a text with a number that has thousands separators but I don’t want thousands separators. Does anyone know how to correct the formula so that it has the format without thousands separators?

thanks from now

2

Is there a reason you want the year as text? I think you need to do this in two steps. First, have the ‘Year’ column type as number and set to =YEAR(Date), and in the column definition make sure thousands separator is turned off. Then refer to this in whatever expression you are using as TEXT(Year).

1 Like
3

Not sure what you’ve got inside TEXT() but try SUBSTITUTE(TEXT(…),“,”,“”) to remove all commas

2 Likes
4

Hello how are you? Well actually the reason is that I want to concatenate the name of the month and the year and to do so I thought it was convenient to change its format to text. It happens that if I leave it as a number and remove the thousands separator, when concatenating, the update leaves me a number 45637 instead of jun-2023

5

substitute(TEXT(year([Data])),“.”,“”)