Excel Format change

Ho to convert 0001 into 1 in excel? Suggest me any query?

Hi there,

The problem you have is not solved by querys or power querys its a setting or import issue.
This might help? Its a tutorial how to add those 0’s but i gues reverse engineering it, would work fine.

And if this does not work for you, you can always buffer it out in UIPath.

Kind Regards,
JR

Hi @palanikumar
Can you elaborate this more? Thank you :slight_smile:

Actually I want in reverse format you shared. I have values in my excel in the format like “00003215” but i want this value like this “3215”

I know, but you can reverse engineer the tutorial. IF you know how to add the 0000 you know how to delete them :wink:

Hi @palanikumar.
Use this in Assign activity. Let’s say the variable name is strTrial
strTrial = CInt(strTrial).ToString

See reference here:
https://social.msdn.microsoft.com/Forums/vstudio/en-US/f296e971-2f7e-48d5-9d50-2465599ba7a0/removing-leading-zeros-from-an-number?forum=vbgeneral

Let me know if this works.
Thanks and regards :slight_smile:
Despi

1 Like

Hi,

To change format in the excel you can use the activity called “ChangeCellType”. Here is the link.

Regards
Balamurugan.S