Converting the format from general to text after pasting the data

Help Studio
, ,
1

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 ?

2

Hi @Kunal_Jain ,

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

image

Regards,

3

No It is not giving the required output

4

@Kunal_Jain ,

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

Regards,

5

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