You need VBA for this

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html



--
Regards,

Peo Sjoblom


"dsfb" wrote in message
...
i would like to know how to keep track of the invoices and have it
automatically show up with the next number every time i open a new
invoice,
how can i accomplish that?