Hi @Nelly ,
The problem is with excel that when your writing it to the excel the column format is getting it as Number.So we need to change it to general. For change it to general I have provided you the VBscript please use it in desktop with RunVBscript action as shown in below and change the column.
VBCode:
Please copy the below code into VBscript action.
Option Explicit
Dim xlApp, xlBook, xlSheet
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True ' Make Excel visible for demonstration purposes
' Open the Excel file
Set xlBook = xlApp.Workbooks.Open("C:\Users\OneDrive\Desktop\Power Automate Desktop\Practice\Excel\Positive.xlsx")
Set xlSheet = xlBook.Worksheets(1) ' Assuming you want to work with the first worksheet
' Get the range of column B
Dim columnBRange
Set columnBRange = xlSheet.Columns("B")
' Change the format of the column to general
columnBRange.NumberFormat = "General"
' Save and close the workbook
xlBook.Save
xlBook.Close
' Quit Excel application
xlApp.Quit
' Clean up
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
