Thank you all for the rapid responses. This is the formula that I was able to
get to work. =concatenate("T",TEXT(A1,"000000000"))&TEXT(A2,"00 0000000000")

This is probably what you were trying to tell me.

Thanks Again

"Art" wrote:

I am trying to create a string of numbers from 2 different number formats.
The formula I am trying is on test tab 3 =concatenate("T",Test1!A1,Test1!A2).
I have created custom format 00000000 for A1 and custom format 000000000000
for A2.
A1 has 000000006
A2 has 000001212422

I would like it to return T000000006000001212422 but it returns T61212422.
Any ideas on how to make it work?

Thanks