Thread: formula-add invoive number to new invoice.

Hi

please help, i'm using excel 2007 and 2010 and i want to create an invoice template for my business to increase value of invoice every time i open a new invoice. eg. when i open a new invoice it must display 00001 and when i open the fourth one must display 00004 and the 20th one must display 00020.


please help me with the correct formula.

Hi and welcome to the board

Why not create the invoice in Word and your DB in XL numbering each row.
Then use Mail Merge options form Word