Hi

Take a look at J E McGimpsey's solution at
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Regards
Roger Govier



"Revive-A-Disc" wrote in message
...
Hi,
I was wondering whether anyone knew how to do the following:
How do I create a formula that continuously numbers my invoices, e.g. 001
(first invoice) then when I go to type another invoice it numbers is 002.

PLEASE HELP!

Cheers