How to Change the Type of a Column in a datatable from String to Number?

[Palaniyappan (Palaniyappan P)]

Hi

@Sirimalla_Karthik_Chandra

table and the database table expects only int32 values for few columns.

May be you can do like once after writing the data to a excel then you can use this macro to change the column format

Convert cell or range value from text to number [Excel][Vb]

@AS07 - Here you go… My Input [image] My Output After running the macro… [image] VBA macro i used…(Write it in a notepad and saveas .vbsfile…) My workflow Sub macro() Range(“C:C”).Select 'specify the range which suits your purpose With Selection Selection.NumberFormat = “General” .Value = .Value End With End Sub [image]

Or

if you want to change it in datatable level itself as a int32 type then refer this

Datable Column as string. Need as Integer

Hi Hoping someone can help me with this please? I have the following datatable - Search Results DT. This has pulled through where all columns are string. I need column “Days_Open__c” to be an integer so I can use the filter datatable activity. I can’t seem to make sense of anything I have read in the forum for this issue but it has been asked a few times. Does someone have a quick fix that will mean I don’t have to create a new datatable?

Cheers @Sirimalla_Karthik_Chandra