Consecutive "numbers" in a numbers column.
I am trying to create a column that is automatically number 2019-001 through 2019-1000. I have tried the standard ways but keep getting an error as it appears that numbers does not consider 2019-XXX as a number. I am certain that this is relatively simple but I can't seem to grasp it.
Thank you all in advance.
assuming that the result, "2019-001", is to be in the second row and subsequent results in the column below...
And that the column you plan to use is column A
select cell A2, then type (or copy and paste from here) the formula:
="2019-"&NUMTOBASE(ROW()−1,10,3)
shorthand is:
A2="2019-"&NUMTOBASE(ROW()−1,10,3)
To fill down, select cell A2, copy
now select cells A2 thru the end of column A, paste
to add more rows, select all of the cells in column A (except the header row), then type the key combination
<option> + <down arrow>
repeat this until you have all the rows you need or want. To add groups of 10, select 10 cells, then type the key combination
there is a limit of 65535 rows.
assuming that the result, "2019-001", is to be in the second row and subsequent results in the column below...
And that the column you plan to use is column A
select cell A2, then type (or copy and paste from here) the formula:
="2019-"&NUMTOBASE(ROW()−1,10,3)
shorthand is:
A2="2019-"&NUMTOBASE(ROW()−1,10,3)
To fill down, select cell A2, copy
now select cells A2 thru the end of column A, paste
to add more rows, select all of the cells in column A (except the header row), then type the key combination
<option> + <down arrow>
repeat this until you have all the rows you need or want. To add groups of 10, select 10 cells, then type the key combination
there is a limit of 65535 rows.
You could change the hyphen (-) into the dash (—).
Format the cells in column A as “TEXT”.
Enter 2019—001 in A2.
Fill down in column A.
In A3 you will see 2019—002;
In A4 you will see 2019—003
………
Paul.
Ahh, a solution has been found. It is interesting that it will fill down as desired with an "em dash" vs the plain old hyphen everyone uses all the time. I see it also works with the "en dash". The en dash can be typed on the keyboard as Option-Hyphen. The em dash is Option-Shift-Hyphen.
Thank you Paul.
Yours is also an excellent solution and was extremely helpful.
Thank you very much Wayne! This did the trick.
Consecutive "numbers" in a numbers column.
