J0ska
22
Sure, bcause it is thousands separator.
1 Like
Soudios
(Sou)
23
i need to keep this configuration system in my computer
Gokul001
(Gokul Balaji)
24
Hi @Soudios
It’s Working Check the screenshot.
Regards
Gokul
1 Like
Soudios
(Sou)
25
@Gokul001
Its working with a specific number i need it to work with a hole csv file
Soudios
(Sou)
27
@Gokul001
I can’t share it with you, what do you need to know about the csv file ?
Gokul001
(Gokul Balaji)
28
Hi @Soudios
Can you share a dummy CSV file and error screenshot
1 Like
J0ska
29
As stated before it seems to be locale settgins conflict:
- your CSV is using comma as decimal separator
- your system is comma as thousands separator
I recommend you to resolve it by replacing “,” by “.” in your number, e.g.
MyNumber = “123,456”
MyNumber = MyNumber.replace(“,”,“.”)
This is a dummy solution but should work.
Cheers
1 Like
Gokul001
(Gokul Balaji)
32
@Soudios
Can you share the Dummy CSV file?
Otherwise, I cant help you…
1 Like
Soudios
(Sou)
33
Here an example of numbers with 2 decimal after coma

Soudios
(Sou)
34
in your code i need to replace “MyNumber” by a csv file
J0ska
35
The solution proposed by @ppr before works well for all variants:
1 234,56 → 1234.56
234,56 → 234.56
234,567 → 234.567
1 234,567 → 1234.567
MyNumber = “1 234,56”
MyNumber = Double.Parse(MyNumber, System.Globalization.CultureInfo.CreateSpecificCulture(“fr-FR”)).ToString
Howgh
1 Like
Soudios
(Sou)
36
@J0ska
I have 200000 row in this file, did a need to add MyNumber= “1 234,56” 200000 times ? 
J0ska
37
This is a different story - you read CSV into a datatable and seems you do not know how to apply the formula to the datatable.
Cheers
1 Like
J0ska
39
This is quite common topic. Many resources about this topic in this forum and Internet.
Search pls.
Cheers
Soudios
(Sou)
40
@J0ska
Ok no problem if you don’t know how to do it
Soudios
(Sou)
41
Anyone knows how to do it with the hole process plz ?
Hi ,
Can you try this method, auto fill range can be extended till last row.Main.xaml (8.8 KB)
sample.xlsx (8.7 KB)