Hey BJ,
Although your formula didn't work 100%, I thank you for your help. Your
formula got me on the right track, and I'm grateful you were there. Thank you.
Please see the note I sent to "Harald".

"bj" wrote:

I assume you have other cells with the lookup information.for example
C1 Last name
C2 Num of jobs
C3 date
c4 pages
try
=Upper(left(C1,3)&text(c2,"00)&if(month(c3)<10,"0" ,"")&month(C3)&if(day(C3)<10,"0","")&day(C3)&if(mo d(year(c3),100)10,"0","")&mod(year(c3),100)&if(C4 <10,"0","")&c4
"Murphey's Law" wrote:

I have created an invoice/proposal template that I want to have the invoice
numbers to be generated automatically to reflect the first three or four
letters of the customers name (in caps), how many times I've done business
with this individual, the month,day, and year of when the invoice was
created, and how many pages in the proposal/invoice were created. An example
of "Mr. Jones" second time doing business with me, written on May 28th, 2005,
and having three parts to the proposal, would look like this: JON0205280503.
Any suggestions would be appreciated.