sorry
The value “102,562” should read “one hundred and two”
In that case your system - system locale - is set-up to interpret comma as thousands separator (not decimal separator) → before writing to Excel replace comma “,” by point “.”
And indeed check your system locale.
Cheers
@ppr
so i need to use read column activity after copying the csv file in the excel file and replace it instead of 102,562 in your sentence right ?
Double.Parse(ColonneDecimal.ToString, System.Globalization.CultureInfo.CreateSpecificCulture(“fr-FR”)).ToString
@J0ska
i have any problem if the number have 2 decimal ==> example 120,05
but if the number is 120,503 it doesnt work
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