Excel operation

studio

#1

excel

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
#2

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)

Regards,
Ashish


#3

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?


#4

this isssue is solved by Split number into different parts