in excel itself you can just use the formula “value” it will change it to a number but it will also remove the zeros in front
You can try these ways.
- read the excel using excel activity [ excel application scope] & write it to same excel using write range. This may convert the text format to number
---------------------------------- OR----------------------------
- Another way would be to use VBA, use invoke VBA activity to run vba script to convert the type of cells from text to number.
Thanks & Regards,
Nived N
the excel I have to process. is with the formula. I would like to change it to Numbers. when I copy the file to another excel file.
@Nightowl_music First method from @NIVED_NAMBIAR should work, just set the “read range” to “raw values” and you will have numbers.
Use format range to change the format to number
And also make sure the column type is int32 or double in the datatable when you paste
https://docs.uipath.com/activities/docs/format-range-x
Cheers
I need to get rid op those green anchors in excel. doesn’t work with this method.
it’s original input file, want to transfer it to another excel file and get rid of the green anchors.
Read the data and write using formula then
= Text("002134","000000") in excel
In write cell activity use as below
= Text(""002134"",""000000"")"
Cheers
I only want to use excel using the UiPath studio activities
ok thanks, but I have also letters before the numbers, like CR00200101
If you have letters then you won’t get that error at all…So for those you need not add text() as well
cheers
is not working, I need to get rid om the green anchors. and still keep the number like:
CR00200101 and 00200101
May I know what is the column type in excel?
and even with text the error is not going off?
can I see how you are trying it
cheers
is type text
Yoichi
Anil_G
jast1631
Gokul001
yedukondaluaregala
Jon_Smith
adi.mehare