software

I wasnt sure what to give as a title for my question.

What i have:

cell a1 is an input cell for a year the year is quot;2005quot;

then the next 20 cells in row 1 are taking cell a1 plus 1.

so cell a2 would be quot;2006quot; and cell a3 would be quot;2007quot;.

I was wondering if anyone knows a way to make it so I can have the
cells look like this. quot;2005-06quot; or quot;2005-2006quot; or quot;05-06quot;

the cell a1 input would be one of the example above and then cell a2
would be quot;2006-2007quot;.

thanks for the help.--
nelsok
------------------------------------------------------------------------
nelsok's Profile: www.excelforum.com/member.php...oamp;userid=30682
View this thread: www.excelforum.com/showthread...hreadid=503445Put 2005-2006 in a1 and type this into A2:
=LEFT(A1,4) 1amp;quot;-quot;amp;RIGHT(A1,4) 1
Copy down...
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;nelsokquot; gt; wrote in
message ...
gt;
gt; I wasnt sure what to give as a title for my question.
gt;
gt; What i have:
gt;
gt; cell a1 is an input cell for a year the year is quot;2005quot;
gt;
gt; then the next 20 cells in row 1 are taking cell a1 plus 1.
gt;
gt; so cell a2 would be quot;2006quot; and cell a3 would be quot;2007quot;.
gt;
gt; I was wondering if anyone knows a way to make it so I can have the
gt; cells look like this. quot;2005-06quot; or quot;2005-2006quot; or quot;05-06quot;
gt;
gt; the cell a1 input would be one of the example above and then cell a2
gt; would be quot;2006-2007quot;.
gt;
gt; thanks for the help.
gt;
gt;
gt; --
gt; nelsok
gt; ------------------------------------------------------------------------
gt; nelsok's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30682
gt; View this thread: www.excelforum.com/showthread...hreadid=503445
gt;
Hi

One way, Formatgt;Cellsgt;Numbergt;Customgt; 0000 - 0000
In A1 enter 20052006 and it will appear as 2005 - 2006
In A2 =A1 10001
Copy down as far as you need

--
Regards

Roger Govierquot;nelsokquot; gt; wrote in
message ...
gt;
gt; I wasnt sure what to give as a title for my question.
gt;
gt; What i have:
gt;
gt; cell a1 is an input cell for a year the year is quot;2005quot;
gt;
gt; then the next 20 cells in row 1 are taking cell a1 plus 1.
gt;
gt; so cell a2 would be quot;2006quot; and cell a3 would be quot;2007quot;.
gt;
gt; I was wondering if anyone knows a way to make it so I can have the
gt; cells look like this. quot;2005-06quot; or quot;2005-2006quot; or quot;05-06quot;
gt;
gt; the cell a1 input would be one of the example above and then cell a2
gt; would be quot;2006-2007quot;.
gt;
gt; thanks for the help.
gt;
gt;
gt; --
gt; nelsok
gt; ------------------------------------------------------------------------
gt; nelsok's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30682
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=503445
gt;

thanks... both ways do exactly what i need them to--
nelsok
------------------------------------------------------------------------
nelsok's Profile: www.excelforum.com/member.php...oamp;userid=30682
View this thread: www.excelforum.com/showthread...hreadid=503445