Value change in Meriging and write range data table

[Gokul_Murali]

Hello guys i have excel iam merging and write range into another excel

But while writing the column is changing
This is the actual column

And it is changing to this

But only this excel is having the issue all other values are writing correctly

I have used for each to display and correct value is displaying

Can i get a solution for this

[ashokkarale]

@Gokul_Murali,

It seems issue of Column formatting. Use Format Cells activity to format the column values in desired format.

Activities - Format Cells

Thanks,
Ashok

[pravallikapaluri]

Hi @Gokul_Murali

Try by using format cells activity and then save the excel.
After that try to write the data into excel

Hope it helps!!