Insert Number to specific Column in Excel

[Israel_Silva]

Hello, I have an excel file, where I need to insert the number “0” in front of all the data of a specific column, can anyone help me?

The data must look like the highlighted image below

[Gokul001 (Gokul Balaji)]

Hi @Israel_Silva

You can check ot the video link : You can pass the cell value based on requirement

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

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

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Another Method @Israel_Silva

You can also try with Format cell activity

Check out the the Tutorial

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

Regards
Gokul

[Israel_Silva]

Exemple.xlsx (57.0 KB)
Thanks for the suggestions, but I couldn’t solve my problem,

I’ll put xlsx as an example, I just need to add 0 in front of each number in the “Division” column

[supermanPunch (Arpan)]

Hi @Israel_Silva ,

Could you try with the workflow below :
Excel_PrependZeroToColumnValues.xaml (6.4 KB)

Let us know if this is not as expected and mention the difference between your actual outputs required.

[Israel_Silva]

this is exactly what i wanted, thank you very much

[Aleem_Khan (crazy bot)]

I need your help to understand your solution I am getting confuse about below query I have seen you convert column into array can you please explain query to add zero

(From r In DT.AsEnumerable
Let ra = columnNames.Select(Function(c)If(c.Equals(“Divisão”),CObj(“0”+r(c).ToString),CObj(r(c).ToString))).ToArray
Select OutputDT.LoadDataRow(ra,False)).CopyToDatatable

please explain in detail really appreciate you
Thank in advance