Concatenate custom cells

[Lou]

I've managed to concatenate 4 cells into 1 but they are custom format
(as they need to be a certain length) so many have leading 0's. The
cell displaying the joint information is missing out the 0's. How can I
get the concatenation to show all the numbers?

eg. 06263212103641 + 09940351822154315 + 0000000000461579 =
62632121036419940351822154315461579 but I want
06263212103641099403518221543150000000000461579

 

[dh01uk]

Have you tried changing the format for the cells you want to combine to
text first?

Regards
dh01uk

 

[JE McGimpsey]

One way:

=TEXT(A1,"00000000000000") & TEXT(A2, "00000000000000000") &
TEXT(A3, "0000000000000000")

 

[Lou]

When changing the number to text it doesn't retain the correct
number.... changes 06263212103641 to 1.62632E+13

 

[JE McGimpsey]

Then you didn't use the TEXT() functions the way I illustrated.

Are you trying to add the strings (i.e., using "+") rather than
concatenate ("&")???

That wouldn't explain your example, 06263212103641, if anything, should
be changed to 6.26321E+12, not 1.62632E+13

 

[Lou]

Worked a treat, thanks very much.