Activity "read csv" changes the content of the cell

Hi,

In excel I have numbers that consist of 14 digits. After use activity “Read csv” their content is changing.

Before:
image

After:
image

Is there any way to prevent this?

make that excel column’s datatype as number

That shortening is done due to excel’s auto formatting

@rahulsharma

Column datatype is general.

So nothing can be done about it?

Hi
Have a view on this thread

Cheers @Paulina_x

Pardon! The format should be Number and with no decimal

image

There is a custom activity to do so, check that out, from the master @balupad14

1 Like