Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying year
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying year
#1. Use real dates.
I'd put this in the top cell (say A1???): =date(2007,3,1) Then in a2: =date(year(a1),month(a1)+1,1) and drag a2 down as far as you want. And give those dates a custom format of: MMM YYYY #2. If the .xls file was opened in MSWord and saved as a document (but still with a .xls extension), then you'll see the error. You may be able to retrieve some data by opening the file in MSWord and copy|pasting to a worksheet in a new workbook. You might be better off by restoring/using a backup version. 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
How do I calculate year vs. year sales in a percentage? | Excel Discussion (Misc queries) | |||
how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |