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 …

Change amount column values in excel to standard format of 1,234,567.89

Pradeep_Shiv (Pradeep Shiv) March 10, 2020, 7:32am 2

you can go through this post
@ui2507path

Topic		Replies	Views
How to set amount format in excel with separator Activities uiautomation , activities , question	1	619	June 2, 2022
How to change string format Studio studio , question , activities_panel	12	389	October 27, 2023
Need to modify the column format in .xls file Activities excel , activities , question	28	310	May 8, 2024
How to change Excel format of multiple cells to number Studio uiautomation	3	724	March 25, 2021
Excel column format change Help	9	13780	February 22, 2022