Percentage in Data Table

Hello everyone, I have this kind of data in an excel file:

When I save in Data Table and paste the data into a new file this is what I get:

Do you know how I can format my DataTable or have the identical data?


While reading the data you can select the Preserve Format property of Read Range activity, this might solve your issue.


It’s because actual data is 0.08170284 and it’s set percentage format in source worksheet.
So, can you try either of the following?

  1. Set format as percentage in new sheet using FormatCells activity.


  1. Use PreserveFormat option in ExcelApplciationScope or DisplayValue at Read formatting in UseExcelFile activity.



1 Like

Nice ! Thanks YOU !

1 Like

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