Try

="T"&TEXT(A1,"00000000")&TEXT(A2,"000000000000" )

edvwvw

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1