Convert cell or range value from text to number

[Nightowl_music]

RPA Facturen.xlsx (139.0 KB)

dit is my data, the robot is not reading it because of the green anchors. what is the best way to get rid of it ?

[Nightowl_music]

data is: number and number with CR before. i want to keep them both

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

@kirankumar.mahanthi1

Dim excel As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
Dim ws As Microsoft.Office.Interop.Excel.Worksheet
Dim cell As Microsoft.Office.Interop.Excel.Range

Try
excel = New Microsoft.Office.Interop.Excel.ApplicationClass
wb = excel.Workbooks.Open(“Your excel file path”)
excel.Visible=True

ws=CType(wb.Sheets(“Your Sheet Name”),Microsoft.Office.Interop.Excel.Worksheet)
ws.Activate

For Each cell In ws.Range(“E2:E10”).Cells
cell.Value = cell.Value
Next

Catch es As Exception
'System.Windows.MessageBox.Show(es.Message)
End Try

wb.Save
wb.close
excel.Quit
wb=Nothing
ws=Nothing
excel=Nothing
GC.Collect()

Hi @Nightowl_music ,

Please find the attached sample process for your reference on converting the text to number.

ConvertTextToNumDemo.zip (8.4 KB)

and also make sure that you have added the name spaces - microsoft.office.interop.excel