I have a DataTable with a column containing numbers. I am formatting it in 0.00 format using the LINQ query below, but it is showing an error. Can anyone help me? DT1.AsEnumerable().Select(Function(row) row.SetField(“Number”, String.Format(“{0:0.00}”, Convert.ToDouble(row(“Number”)))) Return row …

Format a Data Table column using LINQ

chandreshsinh.jadeja (Chandreshsinh jadeja) January 10, 2025, 5:57am 5

if that query works then please dont forget to mark it as answer

1 Like

Topic		Replies	Views
Change column value using LINQ Activities excel , activities , question	16	2130	January 5, 2023
Unable to use format value activity Studio excel , uiautomation , activities , string , question	0	745	July 21, 2020
Change Excel's column type Activities excel , activities , studio , question	7	1008	October 27, 2023
String.Format isn't working in LINQ Help datatable , studio , question	3	2064	July 12, 2020
Change datatable column type number to date Activities excel , activities , question	7	62	February 6, 2025