concatinate data

R

Rhonda

I have several columns of numbers - some numbers have leading zeros. When I
concatinate the data the leading zero drops off even if I customize the cell
first. Is there any way to have the column data not drop leading zeros when
concatinating?
example:
A B
02536 5525

Concatinated
25365525 desired result = 025365525
Thanks for any ideas!
 
B

Bernard Liengme

Try
="0"&A1&B1
or
=TEXT(A2,"00000")&B2
or
try giving your cell with 25365525 the custom format "000000000" (1 more
zero than existing digits)
best wishes
 
C

CLR

Sounds like your leading zeros are just a matter of formatting rather than
actually being part of the value in the cell......

try something like this.....

=0&A1&B1

Vaya con Dios,
Chuck, CABGx3
 
P

Pete

It depends how you are joining them together. With a formula like:

=A1&B1

entered into C1, this should retain any leading zeroes.

Hope this helps.

Pete
 
R

Rhonda

Thanks Bernard! The formula =Text(A2,"00000")&B2 worked perfectly! Since my
column of data has 5 digit numbers with or without leading zeros the
suggestion works for both data.
Rhonda
 
Top