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!