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
--
mmednick
------------------------------------------------------------------------
mmednick's Profile:
http://www.excelforum.com/member.php...o&userid=29404
View this thread:
http://www.excelforum.com/showthread...hreadid=491172