Hi @Gabojm ,
After writing the Data into the excel ,Please use VBscript action to convert text to number as shwon in below image. Make necesarry changes in Code.
VBCode:
Dim xlApp, xlBook
' Create Excel Application object
Set xlApp = CreateObject("Excel.Application")
' Make Excel visible (for debugging)
xlApp.Visible = True
' Open the Excel file
Set xlBook = xlApp.Workbooks.Open("C:\Users\rv60612\Desktop\Text_To_Number.xlsx")
' Convert values in column A to number format
xlBook.Sheets(1).Columns("A").NumberFormat = "0.00"
' Save and close the Excel file
xlBook.Save
xlBook.Close
' Quit Excel application
xlApp.Quit
' Release the objects
Set xlBook = Nothing
Set xlApp = Nothing
If you using that Cell data which on text as Number you simply use Convert Text to Number action.
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
