Converting the format from general to text after pasting the data

I have an excel sheet which contains the data in the format of text and I need to paste it in the same format but while pasting it is automatically converting to General.
What should be done to convert it ?

Hi @Kunal_Jain ,

While using the read range in excel scope, enable the preserve format property and give it a try.



No It is not giving the required output

@Kunal_Jain ,

Refer to the following thread, it will help you change the data type in excel after writing to it.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.