I would like to start off by saying I have searched for about day and can't seem to get the right formula. Currently, I have a set of numbers (employee ID's). Originally they are all 10 digits but when I pull them out of one of my systems it eliminates the zero's in the front end but in my other system they are 10 digits. I am trying to figure out the formula where I can take the ones that aren't ten digits and make them ten digits long. For example:
Employee ID Name
1234 Employee 1
12345 Employee 2
123456 Employee 3
Essentially, I just want to know how to make the employee id's 10 digits long without using special formats because I can't do a vlookup on that.
Thanks,
Lemon
Employee ID Name
1234 Employee 1
12345 Employee 2
123456 Employee 3
Essentially, I just want to know how to make the employee id's 10 digits long without using special formats because I can't do a vlookup on that.
Thanks,
Lemon