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.