Take a look at http://www.mcgimpsey.com/excel/sequentialnums.html


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Skyeblue" wrote in message
...
Hi!
Is there anyway I can have Excel automatically generate new Invoice number
each time I open the Invoice worksheet?