Two decimal

I have a excel file where the numbers have more as 2 decimals, now I want to use with a type into acitivity max 2 decimals. How can I handle that with the code below.

row.Item(0).ToString.Replace(“.”,“,”)

@M_L
Have a look here:

An alternate on Double or converted Double is:
grafik

1 Like

It also works if I have an amount of; 100.000.000,6548416 ?

@M_L
If it is a String value - then a controlled conversion to double is required and it will work
if it is a double value and visually represented to you with the . for seperator, and , for decimal seperator then it should work as well as it is already a double

1 Like

There is an activity called “Format Value”, you could try that also

1 Like

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