I am working on a small item to read through an Excel spreadsheet and enter info into a payment portal. The issue I am running into is the conversion of a currency column to string. I understand that UiPath reads the number as a Double, but when I read the row using Read Range and then cast that input to a String it appears to move the decimal.
For example, if the InvoiceAmount column value is $425.00, InvoiceAmount.ToString will input 4.25 in the portal field. $875 becomes 8.75, and so on. Just looking for the best practice on converting this; as I receive the spreadsheet from an external source I cannot manipulate how the data is saved internal to the workbook.
@jeremiah.logan
Hello,
you can try using the converting the your amount to the generic variable. try format value activity. dont provide direct value you can provide varible inside to value field.