See:

http://j-walk.com/ss/excel/usertips/tip037.htm

Try using a format of =TEXT(A1,"00000000").

HTH
Jason
Atlanta, GA

-----Original 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
.