Custom Data Type to String Conversion

[Robinnavinraj_S]

Hi @Dr_Raza_Abidi_PhD

if your organization allows to use third party package means
Install Balareva.Excel.Activities

after that in the activities panel search for change cell type activity

if you want to convert whole column like A means you should declare like this “A:A” in cell Tab

copy the destination cell format in excel
follow these steps to find cell format Right click the destination formatted column → Format cells → custom ->copy the value from the type tab

paste the copied format into cell format tab in change cell type activity

finally choose excel file path in change cell type activity

thats it

hope its solves your issue

Thanks,
Robin