I have a list of product ID generated from another system.
The format in excel is already in number and look perfect in the excel file. But when RPA copy that column to search in supplier website, it become like 7.423445E+11.
When I convert it to “Text” with the little green flag at top left of cell. It works in RPA.
I am not sure if this got to do with Excel or RPA? Any advice?