Percentage in Data Table

[DimitriLYR]

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?

Cordially

[Sanjit_Pal]

@DimitriLYR

data in an excel file:

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

[Yoichi]

Hi,

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.

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

Regards,

[DimitriLYR]

Nice ! Thanks YOU !