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!
Solved! Go to Solution.
@tina_bencik use the toSTring() function
@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
Hi, yes this worked, thank you! :)