Format Number in Excel

[Cheung_Ka_Yan_Cherry]

Hi Community. I’m new to UiPath. Appreciate your help.
I have a 13 digits no in excel at Column B. and want to paste 13 digits no. at Column A on a CSV file.

[ByteBreaker]

If you save the file as a CSV and open it again, the cell will revert to scientific notation (e.g., 4.02E+12 ) because CSV files do not retain formatting. If you need to keep the formatting, consider saving the file in Excel’s native .xlsx format.

[Cheung_Ka_Yan_Cherry]

Thanks. I have another question. Which activity I use to replace the write CSV. I want to write it on product_code.xls instead at Column A. I have tried many time (use excel file, copy excel…) but it doesnt work.

[ByteBreaker]

As you are getting output in datatable why not write this datatable toe excel?

[Cheung_Ka_Yan_Cherry]

Thanks. Now I can write it to excel. But how to show 13 digits no. on my product_code.xls. I have tried below.

[lrtetala (Lakshman Reddy)]

Hi @Cheung_Ka_Yan_Cherry

Can you try like below

Input:

Output:

Regards,

[Cheung_Ka_Yan_Cherry]

Thanks for your reply. I have tired but it doesn’t work. I want to copy the data on Sheet 3 at Column B (from the data table). Appreciate if you can help!!

LookForProductCode.xlsx (17.0 KB)

[lrtetala (Lakshman Reddy)]

@Cheung_Ka_Yan_Cherry

@Cheung_Ka_Yan_Cherry

Thanks for your reply. I have tired but it doesn’t work.

It is working for me

Output:

NewExcel.xls (25.5 KB)

Sequence22.xaml (14.4 KB)

Regards,

[ByteBreaker]

In the Format Cells in source provide excel and range which you created in previous step not data table. Then follow below:

1. Click on Set Format to open the Format cells window.
2. At the top of the Format cells window, select the Data Type tab.
3. In the Data Type tab, select the Number format from the list.
4. Set the Decimal places to 0 to display the numbers without any decimal places.
5. Make sure the Use 1000 Separator (,) checkbox is unchecked to avoid adding a comma as a thousand separator.