You can use the text function

=TEXT(A1,"000")&B1

change the number of zeros to what you need or if you always want to pad
with one leading zero

=TEXT(A1,REPT("0",LEN(A1)+1))&B1


--

Regards,

Peo Sjoblom

"czarkzm" wrote in message
...
Hello all!

I'm trying to concatenate an invoice # with another field, and the problem
I'm having is that Excel drops the 0's in front of numbers. I can get
them
to re-appear using custom formating, but when I use the concatenate or
lookup
functions, the 0's aren't really there so my opperation fails!?!

HELP ME!!!

Thanks in advance for your thoughts.

Monk