Length formula

[psuLemon]

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

 

[VoG]

Try

=REPT("0",10-LEN(A2))&A2