DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Software / Programming

Need a small help with MsExcel 2007

2 posts · originally from https://geek.digit.in/community/threads/need-a-small-help-with-msexcel-2007.197537/

M
mr-moustache Original post #1
Jun 9, 2016 at 11:23 AM
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
Desmond #2
Jun 9, 2016 at 12:20 PM
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.