Get the decimal 0 while fetching Excel Cell values

[PALKUMARI_PATEL]

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.

Thanks

[Yoichi]

Hi,

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.

CDbl(cellValue)=CDbl(compareValue)

Regards,

[PALKUMARI_PATEL]

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