Sure, bcause it is thousands separator.
i need to keep this configuration system in my computer
It’s Working Check the screenshot.
Its working with a specific number i need it to work with a hole csv file
Share the CSV file
I can’t share it with you, what do you need to know about the csv file ?
Can you share a dummy CSV file and error screenshot
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.
Can you share the Dummy CSV file?
Otherwise, I cant help you…
Here an example of numbers with 2 decimal after coma
in your code i need to replace “MyNumber” by a csv file
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
I have 200000 row in this file, did a need to add MyNumber= “1 234,56” 200000 times ?
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.
How can i do that ?
This is quite common topic. Many resources about this topic in this forum and Internet.
Ok no problem if you don’t know how to do it
Anyone knows how to do it with the hole process plz ?
Can you try this method, auto fill range can be extended till last row.Main.xaml (8.8 KB)
sample.xlsx (8.7 KB)