You've chosen an interesting combination of the CONCATENATE function and the
& operator.

=concatenate("T",TEXT(A1,"000000000"))&TEXT(A2,"00 0000000000") could be
expressed as
=concatenate("T",TEXT(A1,"000000000"),TEXT(A2,"000 000000000")) or
="T"&TEXT(A1,"000000000")&TEXT(A2,"000000000000 ")
--
David Biddulph

"Art" wrote in message
...
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