Couldn't Change General format to Text format in EXCEL

[Sun_Dar]

Hi Mates,
I am not getting any workaround here, if anyone has any idea pls share here.

Abstract:

• I am reading an input file by using Excel Application scope->Read Range.
• It is actually a number but user kept in general format
• so it is showing like the below (Exponential ‘E+’):
• 
• so the account number is coming in the process like this:
• 
• Please help me to get it in Number or (more preferable) TEXT format

[balupad14 (Balamurugan (BalaReva))]

HI @Sun_Dar,

If you change the format as a number. I will show with exponential . you can use the below activity.

UiPathGo - BalaReva Excel Activities

Hi , In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below. [image] In the Cell Format , can specify the custom format what we have in the excel Like below image. [image] Sample : UiPathGoExcel.zip (18.4 KB) This is the video to configure the package in local. Here is the link to know about the formats. Regards Balamurugan.S

in cell format property. just specify as “0”.

if you want to set the entire column, you can specify the column-like “C:C” in the cell property.

here is the video.

UiPath | How to change the cell or column format in Excel | Guide (datatype)

Regards
Balamurugan.S

[Sun_Dar]

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

[ptrobot]

You can convert it to normal format like this:

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

[Shikhar_Tandon]

Hi,

That is a simple one you can use a vb script and invoke it using invoke vba.

Thats it.

Thanks

[Sun_Dar]

Hello @ptrobot,
Thanks for your insights,
But unfortunately, it is not working for the requirement.
Actual:

Output:

For 99140331620000000 it is resulting as 99140300000000000

[ptrobot]

Hi @Sun_Dar!

The result is correct for the input 9.91403E+16

If you had converted 9.914033162E+16 instead you would have gotten what you have expected. (That is the value in the screenshot from your first post.)