View Single Post
  #1   Report Post  
czarkzm
 
Posts: n/a
Default How do I get zeros to stay in front of a # when using the concate.

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