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.

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

Charles

Kaby wrote:
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.

=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)

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

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

--
Regards,
Tom Ogilvy


"Kaby" wrote:

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.

Hi,

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

Thanks a bunch.

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"Kaby" wrote:

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.