I think using Excel might be quicker. Just use A1=1, A2=A1+1, A3=A2+1 and copy the formula all the way down the page in column A. Next, highlight the entire column, click Ctrl+1, click the number tab, click custom in the Category section and type 10 zeros in the "Type" box, then copy column A where you need it.
Using ME, the only way I coul think of is copying a formula like "if counting integer greater than 0 and less than 10, add 9 zeros in front of the counting integer, next if counting integer greater than 9 and less than 100, add 8 zeros in front of the counting integer, next if number greater than 99 and less than 1000, add seven numbers in front of the counting integer, and so on....
Alex