With this Assign Value “=TEXT(“+row(“yourcolumnname”).ToString+“, “+”dd-MM”+”)”
I am getting below one :
inside cell value of #NAME? in excel shows as =TEXT(2, dd-MM)
But I had modified your assign value as row(“EQPSC UNIT”).ToString+“,"
and I am able to get required output but with comma separator. If I do remove the comma separator it gives me in Date format.
I had tired two options earlier but manually.
after writing the data to an excel, I can custom the cell value for a particular column to m-d in excel then it changes to 2-22 but inside cell value it will be in Date format.
After writing the extracted output to an excel, I had copied the particular column value to an Notepad and again pasted it back to excel file. This time it didn’t show the cell value in Date format. But as 2-22.
To avoid these manual work, I am trying to get help from you guys. Since I have multiple data in multiple excel files.