Excel operation




I have an input file with card information, while reading the file it is showing like this "4.05E+15"
I tried "format cells " in excel file and executed the code . Even after that I am not getting the exact card number.
Is there any option to convert the vlookup code to normal value in Uipath ?

Convert Column to Text

Hi @hemanth_chinna

Just check it on google and got the below to convert scientific notation to numbers.

Try this way.

If not then attached xaml for reference. Just gave a try to convert the same in numbers as required.

Excel_Operations.xaml (9.0 KB)



Thank you so much for the solution, can you please help me how to split the card number(16 digits) in to 4 parts and assign each part in one variable?


this isssue is solved by Split number into different parts