Why does the text() function insert thousands...

Why does the text() function insert thousands separators?

At the very least this should be an option.

I.E. if I use it on a year, eg. 2018 it returns: “2,018”.

Thoughts?

0 5 502
5 REPLIES 5

PS. The workaround of wrapping it in a SUBSTITUTE() seems to work.

E.G.

=IF(ISBLANK([Closed]),“OPEN”,SUBSTITUTE(TEXT(YEAR([Closed])),",",""))

Instead of using TEXT, try with the CONCATENATE.

Hi @Daryle_Tilroe, where is the formula being used? If I try a simple TEXT(2018) or even TEXT(YEAR(NOW())) as the AppFormula in a Text-type column, I don’t see a separator.

I believe @Daryle_Tilroe is using different locale settings and then the TEXT will give a different result.

Just to update/close: CONCATENATE does not do the trick.

Substitute appears to be the only workaround.

I do think at some point the locale issue needs to evolve to the point where field (column) formats can be specified to override.

The biggest motivation for me on this would be dates though.

ISO 8601 cannot be evangelized enough IMHO.

Thanks all.

Top Labels in this Space