Hi
One way, FormatCellsNumberCustom 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 Govier
"nelsok" wrote in
message ...
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 "2005"
then the next 20 cells in row 1 are taking cell a1 plus 1.
so cell a2 would be "2006" and cell a3 would be "2007".
I was wondering if anyone knows a way to make it so I can have the
cells look like this. "2005-06" or "2005-2006" or "05-06"
the cell a1 input would be one of the example above and then cell a2
would be "2006-2007".
thanks for the help.
--
nelsok
------------------------------------------------------------------------
nelsok's Profile:
http://www.excelforum.com/member.php...o&userid=30682
View this thread:
http://www.excelforum.com/showthread...hreadid=503445