Increasing a number by one every month

[david72]

Hi

Could someone please help me,

I have a tab that has data in a column ie

100100010
100200010
100300010
100400010
100500010
100600010

Is there any way I can increase the 7th and 8th digit which is 01 to 02
the following month and then to 03 the following month without doing
data entry.

Thanks for your assistance

David

 

[Roger Govier]

Hi David

With 100100010 in A1, in A2
=A1+10
Copy down as far as required