How do you create voucher number in excel

[cole]

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.

 

[Gord Dibben]

Have a look at JE McGimpsey's site.

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


Gord Dibben Excel MVP