At one time, i knew how to do this. It's been a LONG week.
I have a column with sequentially numbered rows, starting with "1". What i need to do is "pad" each row with a prefix of "0"'s to make an equal string length for each row of 7 characters. Column B, starting with Row 4 is where "1" begins. column AE, starting with Row 4 will be where the new data resides. In the case of B4, the new value would be 0000001, in the case of column B13, the new value in AE13 would be 0000010. What's the formula i throw into column AE to make this happen??
Thanks in advance
james
I have a column with sequentially numbered rows, starting with "1". What i need to do is "pad" each row with a prefix of "0"'s to make an equal string length for each row of 7 characters. Column B, starting with Row 4 is where "1" begins. column AE, starting with Row 4 will be where the new data resides. In the case of B4, the new value would be 0000001, in the case of column B13, the new value in AE13 would be 0000010. What's the formula i throw into column AE to make this happen??
Thanks in advance
james