You can use this funtion for the initial value in A1
=REPT(0,7)&10 ....From this you will get 000000010
In the following cells you can use this formula in A2 and following:
=REPT(0,7)&A1+10 .....From this you will get 000000020
This will always put 7 zeros in front of the number.
However if you want all you numbers to be 9 digits..... In other words you want only 7 0's in front of 2 digit numbers and 6 0's in front of 3 digit numbers (ie 100) you will need to use this formula:
=REPT(0,9-LEN(A1+10))&A1+10
Hope that helps!
Bookmarks