How do I generate a new invoice number when creating new invoice?

hello. i have an invoice template in Excell and I would like to have a new
invoice number for every time i open up the template. Any idea? Thanks

******, have a look here for ways to do it
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"KiddieWonderland" <KiddieWonderland@discussions.microsoft.com> wrote in
message news:D8CFA956-E17B-459F-B34B-7A548A3D9166@microsoft.com...
> hello. i have an invoice template in Excell and I would like to have a new
> invoice number for every time i open up the template. Any idea? Thanks