Probably an easy answer

[hb2474]

I need to make numbers starting with zero's

for example,


000000010

Now the only way I know how to keep the zero's is to put a ' in front of the zeros

Now I want to make a formula so I can have it increment by 10's and still have
the zero's in from of the numbers

so like

000000010
000000020
000000030

I tried a sum formation with +10 but it does't keep the zero's in from of the number. Any help would be great.

[hb2474]

Thanks but I found the answer in a previous post.

[Rutgers_Excels]

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!

[crispbd]

A1's value: '000015

=REPT("0",LEN(A1)-LEN(VALUE(A1)))&VALUE(A1)+10

Output: '000025

this merely copies the number of 0s to the beginning.
If you have a set number of digits (eg 10, then use this)

=REPT("0",10-LEN(VALUE(A1+10))) & VALUE(A1)+10