Paste Data from Datatable as values in Excel

[Caithlyn_Saturos]

I have a extracted datatable from database and in one of the columns have values of 000 like this. and once it got pasted on excel it becomes like this 0.
I want it to be pasted like 000. So i thought of changing the format of a column in excel but it doesn’t work.
How can i do this?

[urvesh.mistry]

Hey @Caithlyn_Saturos,

Try to convert the excel column format to either general or String maybe this will work for you.

[Pratik_Wavhal]

Hi @Caithlyn_Saturos

try using Change Cell Type Activity of Bala Reva

Have a look to the below Thread

UiPathGo - BalaReva Excel Activities

Hi , In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below. [image] In the Cell Format , can specify the custom format what we have in the excel Like below image. [image] Sample : UiPathGoExcel.zip (18.4 KB) This is the video to configure the package in local. Here is the link to know about the formats. Regards Balamurugan.S

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal