I have two excels that I am merging based on a column with values like, “502123FA7601”, “502123384A01”.
Can someone advise on how to preserve the text format as some cell values are updated to “5.0212336E+209” and due to this, the merging is not accurate.
This is the only unique column I have, and hence I have to work with this.
Edit: The excel is downloaded through email automation, and hence any method to convert the column’s format through UiPath itself, would be helpful.
Thank you in advance