Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |