Sure, bcause it is thousands separator.
i need to keep this configuration system in my computer
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
Here an example of numbers with 2 decimal after coma
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
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
How can i do that ?
This is quite common topic. Many resources about this topic in this forum and Internet.
Search pls.
Cheers
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)