J.E. McGimpsey has a solution that many people find suitable:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


"Liz" wrote:

I am trying to create my own invoices - however I'm having no luck with
generating new invoice numbers. For instance I process invoice 001 and save,
followed by processing my second invoice which does not automatically
generate the next invoice number 002, & so on. Could someone please
assist???? Thanking you

Regards, Liz