"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

Let the first character be an apostrophe like this: '007

/Fredrik