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.