Hello,

I am trying to develop an invoice template in excel. Is there a way to have excel generate an automatic invoice number? We number our invoices with the year, and a consecutive number;
for instance 2012-004. The next invoice numbers would then be 2012-005, 2012-006, etc...

I have read tons of posts about this, from msot complex to most simple, but nothing really decisive...


Thanks