=TEXT(A1,"000")&TEXT(B1,"000")

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to combine or concatenate, two, three-digit
values into one, six-digit
value. For example, in column A, I have the value 123
and in column B, I
have the value 456. In column C, I concatenate A & B
into the text 123456.
I run into a problem when the three digit values in
columns A and B contain
leading zeros, such as 031, 002, 067, etc. How do I
combine or concatenate
the two, three-digit values into one, six-digit value
when one or both of the
three-digit values contain leading zeros?
.