# How to create a list of numbers with specific condition

Posted on

QUESTION :

I would like to create a list of number like yymmddaabbbb

yy:year;
mm:month;
dd:day;
aa:specific numbers like 01, 21 ect;
bbbb: from 0000 to 9999

Is it possible to create a list of number like I stated above?
I am beginner in Excel, but I really need to know how to do it.

You asked how to create a list yymmddaabbbb but did not give further details.

For below, the number of rows = the length of your list.

• Start at row 1
• for each row, enter in the cells the following
• In column A enter the desired yy
• In column B enter the desired mm
• In column C enter the desired dd
• In column D enter the desired aa
• In column E enter the desire bbbb
• In column F enter `=CONCATENATE(A1,B1,C1,D1,E1)`
• Copy `F1` to `F2` and so on

Tips:

Excel can help you fill cells. Select two or more cells in a column and in lower right is small square, put your mouse over it and it will turn into a plus sign “+”, click on it and drag it down.

IF you already have an adjacent column full of data, you can DOUBLE click the square box and Excel will automatically fill in the cells to the bottom of the list.

If your selected cells, that you started with, all have the same number, that number will be filled in. The number will stay the same number

If the cells have 1, 2, and 3, Excel will fill in your bbbb numbers to 1000 automatically. Excel will increase the number by one for each row

Excel will also update the formula above so that the row number will update so that `=CONCATENATE(A1,B1,C1,D1,E1)` will become `=CONCATENATE(A2,B2,C2,D2,E2)` and so on. (A1 = column-row)

Your data will consist of a prefix part and an incrementing part.

Say we want the prefix part to be:

2012256677

In A1 enter the formula:

``````=ROW()-1
``````

Then apply this custom format to A1:

“20122256677”0000

Then copy A1 downward: