Hi @joscares ,
Alternately, maybe using IsNumeric
to check whether the value in cell contains a non-numeric or not :
dt = dt.AsEnumerable.Where(Function(r) r("merchantorderid").ToString.Trim.IsNumeric).CopyToDataTable()
Also, to handle the Conversion to Datatable Error, check the following post :