This link:

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

gives two ways of doing it.

Hope this helps.

Pete

On Oct 2, 12:39*pm, nhlanhla
wrote:
i would like excel to automatically generate unique reciept /invoice numbers
which i are sequencial. i can then pass word lock. i do not have Access on my
computer.