cant edit format cells

[ataur rahman rony]

i have no columns or rows for date and year.. i just want this as a shortcut...suppose when we write 2001 and press cntrl key and drag-in...then its shown 2001..2002..2003,,,,,,,,,,,


is there is any solution that i write 2001-02,and drag in then its shown 2002-03,2003-04.......ym trying on it.and i edit custom ..but cant do it.how can i do this!!!!

 

[bojan0810]

If starting year is 2001 then write this in first row (no matter what cell in first row)

=2000+ROW()&"-"&(IF(ROW()+1<10,"0"&ROW()+1,ROW()+1))

Then just drag it down

 

[ataur rahman rony]

If starting year is 2001 then write this in first row (no matter what cell in first row)



=2000+ROW()&"-"&(IF(ROW()+1<10,"0"&ROW()+1,ROW()+1))



Then just drag it down

thanx a loot ......its working ....

 

[bojan0810]

your welcome