Leading zeroes in a text field

I have a situation where I have employee numbers ranging from 1 to 5 digits. I need to add leading zeroes to make the field nine digits total. (I can do this by using Format/Custom/and entering 9 zeroes.) At the same time, I need the field to be a text field, because I need to concatenate it with two other fields and retain the leading zeroes. Therefore, my spreadsheet will have four columns:
Company Number = 0008, Employee Number = 000000001, Dist Number = 03, Concatenated field = 000800000000103. I can't figure out how to add the leading zeroes, but keep that field a text field, so it shows the zeroes in the concatenated field. Thanks in advance for any assistance!

The formula for TEXT(etc.) worked! Thanks!

Now I have another field I need to add to the mix with spaces at the end of a word. Therefore, my columns will be company = 8, employee number = 12345, action = PAYRATE, date = 20070315 with a concatenated field of company with three leading zeros, employee number with nine digits, action which is PAYRATE and should have three spaces at the end to create a field of 10 characters and a date in the format of yyyymmdd. So with the above values, my concatenated field should be 0008000012345PAYRATE 20070315. Thanks in advance for your assistance!!

I am trying to add leading zeroes to some fields and spaces to the end of one field and concatenate all of that into one field. I got an aswer on the leading zeroes piece, but now am adding the "spaces at the end of a word."

Therefore, my columns will be company = 8, employee number = 12345, action = PAYRATE, date = 20070315 with a concatenated field of company with three leading zeros, employee number with nine digits, action which is PAYRATE and should have three spaces at the end to create a field of 10 characters and a date in the format of yyyymmdd. So with the above values, my concatenated field should be 0008000012345PAYRATE 20070315. Thanks in advance for your assistance!!

If PAYRATE is in C1 and should always have 10 characters try

=LEFT(C1&" ",10)

[thats 10 spaces between the quotes]

so in all you'd have

TEXT(A1,"000")&TEXT(B1,"000000000")&LEFT(C1&" ",10)&TEXT(D1,"yyyymmdd")