Increasing a number by one every month

  • Thread starter Thread starter david72
  • Start date Start date
D

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
 
Hi David

With 100100010 in A1, in A2
=A1+10
Copy down as far as required
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum workdays by month from List of Start/End dates 4
Excel 2007 graphs/charts automatically populate with new data 1
A way to increase a number in a cell by using the + key 2
date format 2
Increment Account Numbers 1
compare date range with date in columns and input data from another cell 2
skip one month by one month 2
Access Count dates within a Month 4

Back
Top