Thread: year cant change
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default year cant change
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
Reply With QuoteReply With Quote