Add commas to a data table

Hi,

I have a excel file with data that doesn’t have commas. I’d like to add commas to the entire data table, how would I accomplish that?

image

I want my data table to have commas in every cell

you mean add a comma after each value in the datatable?

So I have data table that contact number like 3452141. I want all cell value to have commas so 3,452,131

Hi @RPA_Path,

Will these numbers always come as integers?

Regards,
MY

No, some are double such 17.8

grafik
But keep in mind for doubles
grafik

(From r in DT.Asenumerable
Let a = r.itemarray.select(Function(v) if(v.Tostring.Trim.Contains("."),CDbl(v).Tostring(“N2”),CInt(v).Tostring(“N0”))).Toarray
Select Clone_DT.Rows.Add(a)).Copytodatatable