You may want to look at the way J.E. McGimpsey approached it:
http://mcgimpsey.com/excel/udfs/sequentialnums.html

hotchickbiker wrote:

I am doing invoices in Excel. Each time i open a new one i need to put a new
number in ....has anyone got a formula so i can avoid repeating numbers...
many thanks

--

Dave Peterson