Get the exact large number from the excel file

Hi

There are two ways

  1. Either change the type of that column to Text in excel file itself and then try to update the data to it so that it doesn’t convert to this format

  2. Or if the file is getting generated dynamically and can’t be set as a template then you have again two options

  • you can use single quote before to the value like this “ ‘ “+ yourvalue.ToString something like this for your reference

  • or you can use Balareva activity - a custom component from UiPath marketplace to change the format of that column as text

Or in addition u can try with this method also which was discussed earlier in forum

Hope this helps

Cheers @Temuulen_Buyangerel

2 Likes