Issue while adding the datat to the queue

[tharani.natarajan]

Hi ,
Dispatcher reads a data (ID) from the excel and adds it into the queue .
ID - 6213295502387270. In queue also i could see 18 digit number

But when performer enters the details it comes like 6.21329550238727E+15 .How to fix this .Please help

[Anil_G (Anil Gorthi)]

@tharani.natarajan

Can you please let us know if this is happening in excel? or where?

what activity are you performing?

cheers

[sasi_poosarla (sasi p)]

@tharani.natarajan

transactionItem.SpecificContent(cint(“ID”)).ToString

Once try in this way…

[Palaniyappan (Palaniyappan P)]

Hi

NormalNumberString = Decimal.Parse(“1.17751151932438E+16”, System.Globalization.NumberStyles.Float).ToString

Refer this thread for more discussion

Couldn't Change General format to Text format in EXCEL

Hello @balupad14, I have already seen your post. but unfortunately, I am not allowed to use any activities other than UiPath Official

Hope this helps

Cheers @tharani.natarajan

[vinitha_yachamaneni]

@tharani.natarajan

Dispatcher reads a data (ID) from the excel and adds it into the queue .
ID - 6213295502387270. In queue also i could see 18 digit number

But when performer enters the details it comes like 6.21329550238727E+15 .How to fix this .Please help

Hello @tharani.natarajan

1. When reading the data from Excel, make sure to specify that the data type should be treated as text. In “Read Range” activity properties, set the “Preserve Format” option to True.
2. After reading the data from Excel, store it as a string variable. This ensures that the number is treated as text and not as a numeric value.
3. When you enter the details, UiPath will treat the value as a string, and it won’t convert it to scientific notation.

[efelantti]

If you are reading from Excel, check if the data is correct in the file. If it is, you can try to use Workbook activities for reading the file. Activities - Read Range Workbook - https://docs.uipath.com/

[Palaniyappan (Palaniyappan P)]

Hope it’s clarified
If yes
Would recommend to close this topic

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

If not we can keep this open for discussion

@tharani.natarajan