I have requirement where the data (numeric value) should not round off itself, I need the original value with decimals eg: 2120000.0046 is appearing as 2120000.0045 I tried changing the column type to text but still, its getting round off. but I need the value to be as 2120000.0046 [image] tha…

simple method we can convert a column type to text Use a excel application scope and read the excel with read range activity and get the output as dt now use for each row activity and pass dt as input inside the loop use a assign activity like this CurrentRow(“yourcolumnname”) = “ ‘ “ + CurrentR…

Stop value getting round off

Help Activities

Rahul_Unnikrishnan (Rahul Unnikrishnan) September 28, 2022, 11:38am 4

Another approach is using the Format cell activity. Using that you can modify the format of the cell as per your requirement.

Thanks

Topic		Replies	Views
How to stop data round off while writing data into an excel file? Activities excel , question	4	1079	September 13, 2022
Trouble reading data from excel Activities excel , studio	13	503	January 18, 2024
Format number excel Activities excel , activities , question	9	1253	February 24, 2022
Csv Output Issue - Don’t want to round off value in CSV file Orchestrator orchestrator , question	14	893	October 19, 2023
Formatting value in cell Activities excel , activities , question	10	2936	August 20, 2022

Stop value getting round off

Related topics