Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a data entry form template in Excel 2003? | Excel Discussion (Misc queries) | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
I need to create gift certificates in excel how do I number each . | Excel Worksheet Functions | |||
Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel | |||
How do I create a personalized heading row in excel (one that rea. | Excel Worksheet Functions |