![](https://image.jimcdn.com/app/cms/image/transf/dimension=475x1024:format=png/path/sed039f50cee9e95f/image/ia47278f5673eb041/version/1528643754/image.png)
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