How do you create voucher number in excel

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.

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" <[email protected]>
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.