Add commas to a data table

[RPA_Path]

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?

I want my data table to have commas in every cell

[jack.chan]

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

[RPA_Path]

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

[muhammedyuzuak]

Hi @RPA_Path,

Will these numbers always come as integers?

Regards,
MY

[RPA_Path]

No, some are double such 17.8

[ppr (Peter)]

@RPA_Path

3452141

But keep in mind for doubles

[Gangadhar_Athili]

(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