When copying excel datatable an inserting, it changes the format

[ushu (Usha kiranmai)]

@eltmo Try the below one

Using LINQ to replace specific value in DataTable without For-Each

Hi, this is the right side (From d In dt_Combined.AsEnumerable() Let ra = d.ItemArray.Select(Function (x) x.ToString.Replace(“-”,“”).ToArray) Select rc = dt_Corrected.Rows.Add(ra)).CopytoDataTable