Formatting the cell value in excel with blue prism

[Geetanjali3]

I got a collection from OLEDB -Data VBO, when I write that collection to Excel it coming with "General" format how can I change format for particular column cell to "Text"?
the prefixed 00 are deleting automatically?
what is the best approach to do it?

 

[rschandu96]

Hii,
Could you elaborate with screenshots, it will helps a lot.

Thanks,

 

[Manpreet Saini]

i am also facing the same issue ..

date format is getting changed to datetime while writing to excel ...

so i need to change the format of column from datetime to date format

 

[jackyjoy123]

i am also facing the same issue ..

date format is getting changed to datetime while writing to excel ...

so i need to change the format of column from datetime to date format

thanks for the awesome information.

 

[lakshmis]

Using MS Excel VBO Utility, I want to format the entire column to date from text. How can I achieve this?
Also the date format should be mm/dd/yyyy. Could anyone please help?