This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to ask how we going to add zero in front of value below so that the length of value for each row is five. My main goal is i want to make all the value under column A , the length all is five, by adding those zero in front.
However, it is quite flexible which mean some value need to add two zero and some need to add three zero, how do we able to aumatically adding zero in front so that all value is 5 in length
The PadLeft() function allows you to add x amount of your chosen character to the field, in order to bring it up to the length you want. In this case 5. There's also a PadRight() function that will do the same but add them to the end: