Padding with zero for entire column

Help Studio
1

Hi,

How to convert the value “1” to “0001” in excel. Im writing a sql query to compare both columns but it throws data type mismatch error because of the type. I want the entire column to pad with leading 0s Uptp number “1000” so that both the columns look same.
Any Suggestion please.

Thanks

1 Like
2

Hi @Muthulakshmi_Thangamuthu,

You can the below activity to format the excel .
In the cell range property, you have to use like “H:H” for entire column.

Video

Thank you
Balamurugan.S

3

Hi,

You can simply use something like
Stringvariable.padleft(4,CChar(“0”))
This would work.

Thanks