E
EllenM
Hello,
I have a column of 1 to 3 digit numbers. I'd like to add leading zeros to
these numbers to make them 6 characters long. I know these values will have
to become text to do this.
After having done that, I'd like to concatenate these values with "GRN".
For instance:
4 becomes GRN000004
10 becomes GRN000010
777 becomes GRN000777
Thanks in advance,
Ellen
I have a column of 1 to 3 digit numbers. I'd like to add leading zeros to
these numbers to make them 6 characters long. I know these values will have
to become text to do this.
After having done that, I'd like to concatenate these values with "GRN".
For instance:
4 becomes GRN000004
10 becomes GRN000010
777 becomes GRN000777
Thanks in advance,
Ellen