How to remove E+ value in excel column

i have read one excel file and pasting it to another excel file but value in third column is changing to 2.000…E+15 how do i change it in proper string or integer?

1 Like

Hi @kishore.shetty

You can get each value in for each row loop with read range activity output out_dt
with a assign activity like this
out_value = row(2).ToString

Cheers


no bro its not working :frowning:

1 Like

Fine @kishore.shetty

Its resolved, here you go
Removexpo.zip (12.8 KB)

Kindly let know whether this works or not

Cheers @kishore.shetty

Did that work for you
@kishore.shetty

cool @kishore.shetty

1 Like

yes it did, Thank you :slight_smile:

1 Like

Amazing, great start for the day…

would recommend close this topic with right comment marked as solution that could help others looking for solution under your topic @kishore.shetty

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