Can't Sum a column

[abdel (Robot usa)]

Hello Friends,

I’m stack in this Excel file, i want to sum the “Column15”, i used : Cdbl, convert.todouble, it gives
62217013 instead of 622170,13
any help please
Excel File.xlsx (268.1 KB)

[ppr (Peter Preuss)]

With using the corresponding loca we can control the decimal/group seperator character

How can i get a double from string with starting 0,

the comma lets interpretate the Conversion function in default mode that it is a GroupSeperator and is not recognizing the comma as decimal seperator. we can do it eg like [grafik] First line is parsing 0,70 by applying local numberformats into a double correctly We do see it as 0.70 is the internal representation of this number Kindly note: the internal format of Double we do not touch. In case of we do need another format representation we do it by toString (line2) So just adopt the loca…

[abdel (Robot usa)]

i had tryed:
Double.Parse(" 1.400,66".Trim, System.Globalization.CultureInfo.CreateSpecificCulture(“en-EN”)).ToString

but it gives an error: string format is incorrect !!!

[ppr (Peter Preuss)]

Yes, as EN is not specifiying comma as decimal seperator. Use the right culture e.g. as given in the link

As an alternate we can reformat with following activity:

we can do it also with a macro, as a last resort

please do not post within duplicated posts / threads. Thanks

How can i get a double from string with starting 0,

tryed: Double.Parse(" 1.400,66".Trim, System.Globalization.CultureInfo.CreateSpecificCulture(“en-EN”)).ToString but it gives an error: string format is incorrect !!!

[Dawodm (Mahmoud Dawod)]

You can change the format of this column after you did the sum.
To do that you can watch this video: UiPath | Format Numbers In Excel Column with VB.NET | How to set Number formet to Excel Column - YouTube

Best regards
Mahmoud