Originally Posted by flipped cracka
open excel. select all the cells, and then right click and select format cells. then go down to custom, and in the box put "0000". then put 0000 in the first cell and 0001 in the second cell. then select them both, grab the little box on the bottom right of the cells, and drag it down to row 9999. it'll put all the number in there for you.
I'm having trouble with this. Select all the cells vertically or horizontally? And when I dragged the 2 cells it just filled all of them with 0000 and 0001... what am I doing wrong?