Hi guys, I have an excel file with an amount column that can have any type of values like 42,350.80 or 1232,00 or 1234.50 etc and I need to update all these values as 42,350.80 and 1,232.00 and 1,234.50 respectively. That means the output format should have ‘,’ as group separator and ‘.’ as decimal separator. The excel column is formatted as General.
Can someone please tell me how this can be done.
I tried using Format Value activity, it works for most of the values but fails for values like 1234,00 and returns 123,400.00 which is incorrect.
Please advice the correct method to achieve this.