iferror
Member
Hi Excellers,
in a macro my goal is to read numbers from different xls and xlsx files, do some calculations and then export results in a csv.
The decimal separator in the output file is point. As i get input files from various region in the world, the decimal separator can vary.
I tried text to column as i have an entire column to standardize, but i may have done something wrong as it did not work for all the cases.
Input value 77.410,83 --> Output expected 77410.83
Input value 77410,83 --> Output expected 77410.83
Input value 77410.83 --> Output expected 77410.83
Input value 77,410.83 --> Output expected 77410.83
I am pretty sure someone here has already a smart solution to this problem.
in a macro my goal is to read numbers from different xls and xlsx files, do some calculations and then export results in a csv.
The decimal separator in the output file is point. As i get input files from various region in the world, the decimal separator can vary.
I tried text to column as i have an entire column to standardize, but i may have done something wrong as it did not work for all the cases.
Input value 77.410,83 --> Output expected 77410.83
Input value 77410,83 --> Output expected 77410.83
Input value 77410.83 --> Output expected 77410.83
Input value 77,410.83 --> Output expected 77410.83
I am pretty sure someone here has already a smart solution to this problem.