Get the decimal 0 while fetching Excel Cell values

How should I get entire decimal values from Excel ?
I am using read range activity to read few columns from Excel and using that to compare with some other data.

EX: 240.60
I am getting 240.6 only from Excel and which is giving me wrong as Numbers not matching . My Comparison number is also 240.60.



Can you try to set ReadFormatting “DisplayValue” if you use Modern.
Or set true PreserveFormat option of ReadRange etc if you use Classsic.

If you want to compare them as numeric, try to use the following expression, for example.



1 Like

Hello @Yoichi Thanks for the respond. I am able to get it through Preserve Format.

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