1. put 100 in an un-used cell
2. copy the cell
3. select the cells you want to increment
4. Edit PasteSpecial Add
5. re-select the same cells you just incremented
6. Format Cells... Number Custom 0000000

the last step restores the leading zero.
--
Gary''s Student - gsnu200840


"Kiannie" wrote:

How to add these ?

1) 0XXXXX + 100 = 0XXXXXX,
Note: X = numbers, Zero in the front must remain and i need to repeat this
for 1000 rows with all different values for all.
This mean :
0134000 0134100
0123000 0123100
0924820 092920

2) street 27
street 28
street 29

i want to add Road A at the back of each rows, means
street 27 Road A
street 28 Road A
street 29 Road A

What is the formula ?