Make sure that when you paste the formula in, no extra spaces are included in
the paste.

Better to copy from the post and paste directly in the formula bar instead
of the cell.
--
Gary''s Student - gsnu200790


"Art" wrote:

If I use that formula is just displays the formula and doesn't return the data?

"Gary''s Student" wrote:

="T" & TEXT(A1,"00000000") & TEXT(A2,"000000000000")
--
Gary''s Student - gsnu200790


"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