When you placed 2002 in A1 did you right-click, drag down and release and
"Fill Series" or just copied the 2002 all the way down?

You should have 2002 in A1, 2003 in A2, 2004 in A3 etc.

Maybe try 2002 in A1 and 2003 in A2.

Select them both and drag down. They will increment.

I prefer the right-click so's I have to type only one number.


Gord

On Tue, 6 Dec 2005 18:27:14 -0600, mmednick
wrote:


This solution almost seems to work, but instead of:
2002/03 2003/04 2004/05 .... I wind up with:

2002/03 2002/04 2002/05...

Did I miss something or can someone explain what I should do instead?

the N00bish