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!
@Beti1234 use the toSTring() function
@Beti1234 to add to @binu_acs 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!
