Need a small help with MsExcel 2007

mr-moustache

Broken In
Guys, I am working for a educational field where we conduct exam, we enter out data In Ms Excel 2007. Our enrollment Number is total in 15 numeric numbers example like 161110147911001, I would be highly be grateful if you guys help me with the formula to auto generate the enrollment number in sequence 161110147911001,161110147911002,161110147911003........... usually per class school we have 80-90 max. The first 12 digit of the enrollment will differ from place to place.


Thanks a lot in advance

MOds may move the thread to another section if i posted in wrong section.
 

Desmond

Destroy Erase Improve
Staff member
Admin
This could be done easily by entering the first value in a cell then dragging the bottom right corner dot downwards. This will generate a sequence of numbers in the cells below.

If you want to make more complex manipulations, you can create a macro to concatenate multiple values and put them in the respective cells.
 
Top Bottom