Read 0 lead number in excel?

[fairymemay (noona)]

I have data as below. = 02

But after read by uipath = 2

My flow as below.

Now.ToString(“dd”).Contains(Config(“DateLead1”).ToString)

Now Config(“DateLead1”).ToString = 2

Please guide me for read 0.

[mahmoud.zaky]

you can use preserve format option in read range please try it and feed us back if you still face this issue

[fairymemay (noona)]

@mahmoud.zaky I use assign as below.

CInt(Config(“DateLead1”).ToString).ToString(“00”)

It can solve it.

[Che]

If you convert it to an integer, you are going to lose the 0. Simply use Config(“DateLead1”).ToString

[ashwin.ashok ((TheCodingTheory))]

Hi @fairymemay ,

If you wish to preserve its format as you manually write in to Excel, I would recommend prepending a single qoute like so:

Could you try making that adjustment and then try reading it once more from UiPath?

Kind Regards,
Ashwin A.K

[mahmoud.zaky]

could you please check this discussion and solution and feed us back if there is any questions or if this solution not solve your issue.

Convert string to int and keep the leading zero

Hello Everbody, I have an issue when I want to convert string into integer. I get text from a Mainframe and the text is stock into a string variable. I have my str_var as str_FirstPg = “001” I want to convert into int and I did like this : CInt(str_FirstPg), it returns 1. But I need to have the final result as 001. How can I keep the 00, when I convert into an integer ? Any idea, please ? Thank you all !