By now you should have received my response to your email. I provided 2
solutions: one that works by double-clicking on the cell that the invoice
number is to be displayed in, and a second one that uses a .txt file to
'remember' the last invoice number used.
If you have any questions about either, let me know via email since others
can't see the solutions here.

"rmt" wrote:

I dont understand how to put the codes in the vba, please can i email you the
template and you can do it for me, or give me the example of how the code
should be placed. my next invoice number is AM8023. PLEASE.

"JLatham" wrote:

Start with this site - McGimpsey probably has the best explanation of how to
get it done around.
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

You could put AM in a cell, right aligned, and the number returned using his
method in the cell next to it, left aligned, and it would look like AM8023.

"rmt" wrote:

I created a template in excel, now i need to create invoice numbering
starting with AM8023. I am new to 2007, please give me step by step
procedures, Please.