How to convert all these into number format before doing VLOOKUP

[Mayur_N]

I need to do VLLOKUP, and if i want to get the expected output i want to convert that B column into number then I will get my expected output.
How can i achieve that in UiPath while building the workflow?

[adiijaiin (Aditya Jain)]

Hi @Mayur_N

Please use Format Cells activity and set format as Number.
This should be availale under Excel activities.

Thanks!

Happy Automation!

[lrtetala (Lakshman Reddy)]

Hi @Mayur_N

Try this

Input:

Output:

Cheers!!