I have download CSV data from website and use uipath to read and write to another new excel sheet, but i found the data range can’t write correct number what website original one,how can i solve it?
on website data
after read and write to new sheet (i use read and write range)
leading zeros eliminated is OK, i only need the whole number excluding leading zero,
EX:
In Web site: 0000555592000001
download CSC file–>555592000001
what i need data–>555592000001
read CSV and write to new excel it turns out → 55500000000