concatinate data
 

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!

concatinate data
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rhonda" <Rhonda @discussions.microsoft.com wrote in message
...
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!

concatinate data
 

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


"Rhonda" <Rhonda @discussions.microsoft.com wrote in message
...
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!

concatinate data
 

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

concatinate data
 

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rhonda" <Rhonda @discussions.microsoft.com wrote in message
...
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!