Change the format of column in excel

Help Studio
, ,
1

I have a master sheet from which I need to copy the data and paste into the second sheet.
But for some of the columns it is not pasting properly. It is dropping the leading 0.
How to resolve it?

2

@Kunal_Jain

Please try using copy sheet if you need all data…

Alternately in read range activity try using display value and then use write range

Cheers

4

Hi @Kunal_Jain

Can you try this-

Use a formula to force the data to be treated as text:

  • In the destination sheet, select the first cell of the target column.
  • Enter a formula like =TEXT(SourceCell, "@"), where SourceCell is the corresponding cell in the source sheet.
  • Drag the formula down to populate the remaining cells in the column.
  • The TEXT function forces the data to be treated as text, preserving the leading zeros.

Thanks!!

5

Can you just help me where do I need to paste the code??

6

Hi @Anil_G
Actually I am copying the complete master sheet and pasting the data from P2 to the target sheet.
Below Image is the column from master sheet which contains the leading 0’s.
image
But while pasting the data to the target sheet the leading 0’s are getting removed automatically and for some values it is taking as 6.004E+12.
image
How to resolve this issue?

7

@Kunal_Jain

Which activity are you using?

Cheers

8

read range and Write range
Also there is around 12000 records

9

@Kunal_Jain

In read range are you using display values only?

did you try with copy sheet activity?

cheers

10

I tried copy sheet but it did not worked.
Display values
I am not getting.

11

@Kunal_Jain

image

cheers

12

No not getting any solutions with it also

13

@Kunal_Jain

Can you please attach a sample file here

and also did you try with copy sheet activity directly?

or copy/paste range?

and after reading please expand locals panel and check the dt value id it is proper

cheers

14

I have tried copy sheet activity directly