custom format cells

[Guest]

Hi

I would like to use the concatenate function on a group of 4 cells, which
are filled with numbers. The first cell will have 4 digits, and the next
cells will have 2 digits, 2 digits, and 4 digits. I would like to format the
cell so that a 12 digit number comes up when concatenated. However, if for
example I enter 0001 in cell #4, the 0's are dropped when concatenated and
thus have a 9 digit number. How can I do this.

Thanks.

 

[Die_Another_Day]

Assuming everything is stored as text and you want a number:
=VALUE(VALUE(A1)&VALUE(A2)&VALUE(A3)&VALUE(A4))

Charles

 

[Bob Phillips]

=TEXT(A1,"0000")&TEXT(B1,"00")&TEXT(C1,"00")&TEXT(D1,"0000")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

=concatenate(text(A1,"0000"),text(A2,"00"),text(A3,"00"),text(A4,"0000"))

 

[Guest]

Hi,

Since I didn't have my cells stored as text but as custom numbers, the
concatenate text funcion works beautifully.

Thanks a bunch.