Hi,
I have set of columns with numbers which have 3 decimal places.
ex: 26440843.000
10000.000
500000.000
how can I add commas (,) as separator for those examples? I want the result to be:
26,440,843.000
10,000.000
500,000.00
Appreciate your help.
I think this should work:
ToString(ToNumber('500000.000'),3, ',')
Hi @Newb27
Important note on this once you add commas value will no longer be numeric instead it will be a string.
Hope this helps : )