Format cells of Excel

Hi all,
Can anyone please explain how to change the certain column Format cells to Custom type and it should have a length of 8.
Actually I’m copying the data and saving into an excel.In some cases the data is of Integer type and it will start with ‘0’.
Present Output:- 2370666
Actual Output:-02370666
Finally what i want to say is I want to add 0 to each row if it has a length<8.

HI @Shivaraju,

I got the same issue earlier, but don’t find any solution…

What i did is, Instead of using the existing activities, i used Invoke code activity to copy and paste the data. In your case, you need to find the length of the string and then you need to add the zero.

1 Like