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?

Paste Data from Datatable as values in Excel

Pratik_Wavhal (Pratik Wavhal) September 27, 2020, 11:31am 3

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

Happy Automation

Best Regards
Er Pratik Wavhal

1 Like

Topic		Replies	Views
How to Paste DataTable values into Excel Macro file without changing any format Studio	14	1778	September 4, 2020
Convert excel file Academy Feedback studio	1	658	October 12, 2019
Change data type from text to integer in a data table before pasting in excel IT Automation datatable , excel	1	2088	July 3, 2020
How to change a column in excel to text format Studio datatable , excel , uiautomation , activities	3	2134	June 11, 2020
Change excel column in Number Format Help	23	5738	April 29, 2020