Hi Team, I have facing issue of sheet1 excel copy to sheet2 that values of before 0 removed how to keep in 0 value in both sheet1 and sheet2. How to avoid long space in particular column cell values. Please help anyone on this Sheet 1–Input: [image] Sheet 2 --Error [image] Expected Result: …

[image] Raja.G: [image] @Raja.G , If this is the data, Then could you check the below workflow : Excel_Remove_LongSpaceInRows.zip (11.4 KB) Also, I do think that you are missing 000’s in the input as well ?

How to keep 0 before number in excel using uipath

Help Activities

Gokul001 (Gokul Balaji) October 18, 2022, 5:15am 6

Hi @Raja.G

Check out the XAML file

KeepZeroExcel.xaml (5.2 KB)

Output

Regards
Gokul

How to add zero in front of numbers in excel

Topic		Replies	Views
Keep 0 before number in excel Studio studio , question , activities_panel	2	407	July 14, 2023
Padding 0's to the values when it is less then 9 Help	3	2703	April 30, 2019
How to keep text format in read range activity Help	21	5953	January 18, 2019
How to achieve format with preceding 10 zeros to any digit in excel? Studio studio , question , activities_panel	21	3773	August 2, 2021
Delete Zero from Column 2 in Excel Studio excel , uiautomation	5	1400	August 24, 2020

How to keep 0 before number in excel using uipath

Related topics