RegEx - amount format

[tina_bencik]

Hi, I am trying to use RegEx to format my amounts output. I have an amount example 1234.000 but I want to transform it into 1,234.000 or if the amount is 12345.000 I want it to be transformed to 12,345.000 how should I write the formula?

thank you!

[binuacs · Accepted solution]

@tina_bencik use the toSTring() function

[Deano478]

@tina_bencik to add to @binuacs answer if you are adding in commas as value separators you wont be able to keep the value as a number it will need to be converted to string     

[tina_bencik]

Hi, yes this worked, thank you! :)