software

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!

Try
=quot;0quot;amp;A1amp;B1
or
=TEXT(A2,quot;00000quot;)amp;B2
or
try giving your cell with 25365525 the custom format quot;000000000quot; (1 more
zero than existing digits)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Rhondaquot; lt;Rhonda @discussions.microsoft.comgt; wrote in message
news
gt;I have several columns of numbers - some numbers have leading zeros. When
gt;I
gt; concatinate the data the leading zero drops off even if I customize the
gt; cell
gt; first. Is there any way to have the column data not drop leading zeros
gt; when
gt; concatinating?
gt; example:
gt; A B
gt; 02536 5525
gt;
gt; Concatinated
gt; 25365525 desired result = 025365525
gt; Thanks for any ideas!
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.....

=0amp;A1amp;B1

Vaya con Dios,
Chuck, CABGx3quot;Rhondaquot; lt;Rhonda @discussions.microsoft.comgt; wrote in message
news
gt; I have several columns of numbers - some numbers have leading zeros. When
I
gt; concatinate the data the leading zero drops off even if I customize the
cell
gt; first. Is there any way to have the column data not drop leading zeros
when
gt; concatinating?
gt; example:
gt; A B
gt; 02536 5525
gt;
gt; Concatinated
gt; 25365525 desired result = 025365525
gt; Thanks for any ideas!
It depends how you are joining them together. With a formula like:

=A1amp;B1

entered into C1, this should retain any leading zeroes.

Hope this helps.

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

quot;Bernard Liengmequot; wrote:

gt; Try
gt; =quot;0quot;amp;A1amp;B1
gt; or
gt; =TEXT(A2,quot;00000quot;)amp;B2
gt; or
gt; try giving your cell with 25365525 the custom format quot;000000000quot; (1 more
gt; zero than existing digits)
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Rhondaquot; lt;Rhonda @discussions.microsoft.comgt; wrote in message
gt; news
gt; gt;I have several columns of numbers - some numbers have leading zeros. When
gt; gt;I
gt; gt; concatinate the data the leading zero drops off even if I customize the
gt; gt; cell
gt; gt; first. Is there any way to have the column data not drop leading zeros
gt; gt; when
gt; gt; concatinating?
gt; gt; example:
gt; gt; A B
gt; gt; 02536 5525
gt; gt;
gt; gt; Concatinated
gt; gt; 25365525 desired result = 025365525
gt; gt; Thanks for any ideas!
gt;
gt;
gt;