On Wednesday, May 28, 2014 2:45:27 PM UTC+6, Claus Busch wrote:
Hi,



Am Wed, 28 May 2014 01:38:09 -0700 (PDT) schrieb

:



i want to create this format for year-

2001-02

2002-03

2003-04



if you have dates in columns A then try:

=YEAR(A1)&TEXT(ROW(A2),"-00")



else write into the first row:

=2001&TEXT(ROW(A2),"-00")





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

thnx dear...
the thing is 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..........thnx.