What's you format? Use

=TEXT(A1,"0000")&" "&TEXT(B1,"0000")

replace the zeros with your custom format in the text formula


--
Regards,

Peo Sjoblom


"beerguy" wrote in message
...
I have added leading zeros to cell contents in 2 columns. To link data in
this spreadsheet to another one, I need to concatenate the columns. When
I
do this, I lose the leading zeroes from each column, which need to remain
if
I expect to link the spreadsheets. What's the solution?