Quick and easy labeling

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


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?action=getinfo&userid=29404
View this thread: http://www.excelforum.com/showthread.php?threadid=491172

.

Relevant Pages

  • Re: [perfmon] Re: [perfmon2] perfmon2 merge news
    ... criticism of the current set of perfmon2 system calls, ... opposition to the goal of having strong typing of the interface. ... extend but that is at the expense of losing strong typing. ...
    (Linux-Kernel)
  • Re: Contact Highlighting Only Happens Sometimes
    ... > I notice that if I am typing in Word a name that appears in my Entourage ... > make it work regardless of how much info is in the contact? ... pattern right though - I can't find a pattern. ... If you display the Contact toolbar and start typing any contact name in its ...
    (microsoft.public.mac.office.word)
  • OE6 hangs in NewPost or Reply screens sporadically
    ... typing out some response or an original post--only in that screen--I have ... haven't been able to find its remnants yet), but apparently the dirty flag ... This and the pattern of occurrence is leading me to wonder ... (distinctly possible since we've noticed that when it hangs, ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: magic Landing numbers for cessna172 S model.
    ... how far you had to extend. ... an "irregular" pattern work out since every situation is different. ... It's definitely something you can practice with your instructor ... because you are following a much slower plane. ...
    (rec.aviation.student)
  • Re: Searching for multiple conditions
    ... Just extend the pattern ... conditions instead of using -- to coerce them into numbers ... Jerry ...
    (microsoft.public.excel.worksheet.functions)