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.