Naomi, have a look here
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

"Naomi Hall via OfficeKB.com" wrote in message
...
It has been a long time since I have used excel. I know that I had a
invoice set up so that each time I opened a new invoice all of my company
info was saved on it and it was in numerical sequence, 101,102,103.....
Can someone please tell me how i did that so I can set it up again. It has
been so long and i have lost my patience and am very frustrated.

--
Message posted via http://www.officekb.com