Question:I need to make sure all cells in each column have that column’s target length. When the target length is larger than the actual length of the string value in the given cell, x amount of 0s must be added in front in order to make the string’s length be equal to the target.
So far I have this code:
Taking that integer and turning it into 0s that go in front of the cell.value is the issue I am having trouble solving. I have seen solutions to similar problems for Python, but I am very new to coding and I am having trouble understanding the process.
Answer:in the cell like this, e.g. for 10 digits of length:
If you have better answer, please add a comment about this, thank you!