Converting date datatype to string datatype

excel

#1

Hi Everyone,

i have gone through the post and tried to convert my excel date into string type but i am not able to do this. The code which i used is CDate(row(“Transaction_Date”)).ToString(“dd-MM-YYYY”) but when i checked in my excel and click on formal cell i saw that it is showing as date still.