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). Im 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" 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. |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com