How to convert decimal number in custom format to currency format (565.6 KB)
I have to read an excel file (Reportistica Nav v2.xls) containing decimal numbers in custom format and write these numbers in currency format on another Excel file (NAV_O.xls)
I defined the cell format of the output excel file as currency but Uipath transforms it into a custom by placing negative numbers in parentheses. This Uipath behavior does it for numbers with 2 decimals while it does not for numbers with 3 decimals.
In this regard, see Sheet1 in NAV_O.xls
To get the correct output formats I use a template file (NAV_O_template.xls) that I copy as an intermediate output file (NAV_O.xls)