Excel Sequential Numbering

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

Comments: 0