Solved: Text([number]) without thousand separators - Page 2

Gustavo_Eduardo · 07-11-2023 12:18 PM

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

1minManager

Not sure what you've got inside TEXT() but try SUBSTITUTE(TEXT(...),",","") to remove all commas

View solution in original post