Keep 0 before number in excel

[tengku.hazim]

How to keep 0 before number in excel using uipath

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] Regards, Raja G

Referring to the above discussion, I don’t think it is the best solution if we have a bulk of data in excel (e.g. 50K, 100K). Would it be another option to put 0 at the first digit?

Thanks

[pankaj.sharma]

Hi,
Can you add (') before the number in excel and try…?

Kind Regards,
Pankaj

[drbuddepu (DHANANJAYARAO)]

@tengku.hazim Hi, Please use Format cells activity and pass the range by selecting the category as Text. then the 0 will be placed before the value.