year cant change

  • Thread starter Thread starter ataurrahman.acca
  • Start date Start date
A

ataurrahman.acca

hi
i want to create this format for year-
2001-02
2002-03
2003-04

.............
but when i enter 2001-02 and drag-in it give me this result-
2001-02
2001-03
2001-04
............


is any option to create format i need!!!! thanx
 
Hi,



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

(e-mail address removed):






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
Click to expand...

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.
 
ataurrahman.acca said:
i want to create this format for year-
2001-02
2002-03
2003-04

............
but when i enter 2001-02 and drag-in it give me this result-
2001-02
2001-03
2001-04
...........


is any option to create format i need!!!! thanx
Click to expand...

Not with just dragging like that. You need to use a formula, as Claus pointed
out, or else write some code in VBA to handle it.
 
Back
Top