Joining numbered cells prefixed with zero
 

I have 3 columns of numbers. The first column is always 1 number. The next 2
columns are either 2,3 or 4 numbers. I need to combine the 3 columns into 1 9
digit number. The problem I have having is some of these cells start with a
zero (0224). When I try to concatenate them, it strips off the preceding 0. I
need the zero to remain to look like column D.

Example:
A B C D
1 1423 8877 = 114238877
1 0012 0234 = 100120234

Joining numbered cells prefixed with zero
 

=A2&TEXT(B2,"0000")&TEXT(C2,"0000")
--
David Biddulph

"Petee" wrote in message
...
I have 3 columns of numbers. The first column is always 1 number. The next
2
columns are either 2,3 or 4 numbers. I need to combine the 3 columns into
1 9
digit number. The problem I have having is some of these cells start with
a
zero (0224). When I try to concatenate them, it strips off the preceding
0. I
need the zero to remain to look like column D.

Example:
A B C D
1 1423 8877 = 114238877
1 0012 0234 = 100120234