Thread: Copying year
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Copying year

In A1 enter:

=DATE(2003,ROW()+2,1)
and copy down
--
Gary''s Student - gsnu200758


"Ajit Munj" wrote:

1.How can copy the months with same year i.e. Mar 2003, Apr 2003, May 2003
etc because as I drag the cell containing Mar 2003 down, the year gets
incremented
2. Last week I have created marina.xls file which was working fine. But
after 1 week when I trying to open it, the error flashes marina.xls: not a
Excel file format and refuses to open the file? What might have gone wrong?
How can I retrieve the file contents?
Ajit
--
Knowldege is Power