Have a look at JE McGimpsey's site.

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


Gord Dibben Excel MVP

On Sun, 20 Mar 2005 12:11:02 -0800, "cole"
wrote:

We have been updating some of the old company forms and one of the old forms
requires a voucher number for each record. The voucher numbers are created by
the company so I can not start at 1, the statring number would be something
like A101139, I have created a common form in excel, and I would like to and
a voucher number to each form (sometime like a check register number on you
personal checks). I’m not sure how to do this can someone please assist.