Hi,

A couple of ways here.

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

Mike

"Revive-A-Disc" wrote:

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