Paste Data from Datatable as values in Excel

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?

1 Like

Hey @Caithlyn_Saturos,

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

Hi @Caithlyn_Saturos

try using Change Cell Type Activity of Bala Reva

Have a look to the below Thread

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like