There are times when you need to enter very specific sequential number codes, such as purchase order numbers .
The Row function together with the Text function will get you there.
For example, to start a numbered list by using 00-0001, you enter the formula =TEXT(ROW(A1),"00-0000") in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.
Extra Tip: you may want to Copy your range of numbers, and then Paste Special the Values (to remove the formulas in the cells).
Write a comment