| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
"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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I assign sequential numbers in an invoice? | New Users to Excel | |||
| Invoice Numbers | Excel Discussion (Misc queries) | |||
| Generating Invoice Numbers | Excel Worksheet Functions | |||
| Invoice numbers? | Excel Worksheet Functions | |||
| how do you change invoice numbers automaticly | New Users to Excel | |||
Threaded Mode
