I have a process in which I have an excel and from one of the columns I extract a number that has 2 decimals, but when you take it out it does not take into account the decimals. How can I convert an int32 variable to account for 2 decimals?
You can try with Convert.ToDouble(vIn)
It has not worked for me. I have a column with prices in excel, for example 39.99€. I have taken it out as a string variable and do a replace to remove €. I have then a variable that is 39.99 of type string, how do I convert it to a number with the 2 decimal places?
Try this and see whether it works
I put the value 39.99 as an example. I have the numbers in a string variable called price. How should I put it to make it work for me? thank you
Decimal.Parse(row("CurrencyColumn"), (NumberStyles.AllowDecimalPoint Or NumberStyles.AllowThousands), System.Globalization.New CultureInfo("fr-FR"))
@Marisa_Ontiveros - if this is currency, you should use the decimal datatype and not a double as it will keep the precision.
Follow the method @bcorrea mentioned in his post. He is assuming you’re taking it directly out of a datatable. If you have it in a string variable already, just replace the
row("CurrencyColumn") portion with your string variable
You can easily do the above using this code
Assign the above code to a Double Datatype variable using an Assign Activity Let me know about it