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

--
HTH

Bob Phillips

"gerard craggs" wrote in message
k...
HELLO

I HAVE A SMALL BUSINESS, AND I WOULD LIKE TO AUTOMATICALLY NUMBER MY
INVOICES EVERY TIME I REOPEN THE TEMPLATE. THE CELL REFERENCE IS M3.

I HAVE TRIED EVERY THING I KNOW, AND TRAWLED THE INTERNET, BUT CAN NOT
FIND
AN ANSWER. SURELY THIS WOULD BE A SIMPLE THING TO DO.

YOUR HELP WOULD BE APPRECIATED.

REGARDS


GERRY.



--


-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com