Need concatenation help

[n8dine]

I need help concatenating 2 cells. I have two cells where numbers are entered to a max of 5 digits. The cells are formatted so that they reflected 5 digits even if 4 are entered. So if, 01142 is entered, the cell will reflect 01142 instead if just 1142. How do I concatenate these two cells and end up with a result of 10 digits? If cell A2 = 01142 and cell B2 = 09533, how do I get C2 to read 0114209533? Thanks.

 

[VoG]

Try

=TEXT(A2,"00000")&TEXT(B2,"00000")

 

[Scott Huish]

=text(a2*100000+b2,"0000000000")

or

=A2*100000+B2

and format as 0000000000