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

Fresher (Fresher) September 28, 2022, 11:33am 3

@Rahul_Unnikrishnan - Thanks for suggestion, Do you see any other option to stop the value getting round off.

If there are no ways, then certainly I have to create the template to achieve my output

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