How to add a Thousands Separator with ToString or other way?

[StellaBon]

Hello!

I am in the Adapt program and I pulled in my own data for the first time to play around with it. It has been going well and I am feeling good in general in my understanding of the core tools. Hooray!

BUT:

I ran into a problem trying to add a thousands separator to a field. I do not want decimals. This is how I configured it in Formula Tool: 

ToString([Steps per Month],0,1)

However I am not getting the thousands separator. I tried changing the data type and nothing seems to do it.

What am I doing wrong? Is there an alternative way to do this without turning my datatype to a string? Why would one have to convert a numeric datatype to a string in order to add a thousands separator, it seems odd. It's a little thing but it feels like something I should be able to do and do quickly. 

Thanks so much!

StellaBon

[Daleowski]

I am having this same issue. The three 000 in the results window/pane do not keep the comma separators in the output file. The numbers still show without commas. 

[Daleowski]

This is the BEST solution to this question. I was able to use it in my Workflow to add comma separators to my selected numeric fields. 

[Raj]

.