Need help in organizing list
Have column with Emp #, some are 9 digits with first 3 being 000123456
and some are 6 digits without the first 3 zeroes . I want to add 3 zeroes in the beginning to the records that have 6 digits
Emp_No
----------------
000123456
456789
678934
000567834
I want to add leading zeroes to the rows that have only six digits
Have column with Emp #, some are 9 digits with first 3 being 000123456
and some are 6 digits without the first 3 zeroes . I want to add 3 zeroes in the beginning to the records that have 6 digits
Emp_No
----------------
000123456
456789
678934
000567834
I want to add leading zeroes to the rows that have only six digits