Enter 2002 in A1

Right-click and drag down Column A

Release button and "Fill Series" from the pop-up menu.

In B1 enter /03

Drag same as Column A

In C1 enter =A1&B1 to get 2002/03

Drag down Column C.

Copy column C and Paste Special(in place)ValuesOKEsc

Delete A and B columns.


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 13:53:44 -0600, mmednick
wrote:


So if I put 1 2 3 4 5, or 2 4 6 8 acending in a row of cells, then
highlight them, I can pull the row out and extend the pattern out
automatically without typing the numbers.

My question is: Can I preform the same action on date labels in this
format:
2002/03 2003/04 2004/05 2005/06 and so on... using the same type of
click and drag extension and if so, how?

If not, is there a formula I can use that will add one, only to the
appropriate numerals, ie. 2004/05, only the 4 and 5... and so on?

Thanks
The n00bish