Check out

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

In article ,
"John McCormack" <John wrote:

Is there any way i can automatically change an invoice number when i open up
a template of the invoice??