Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extending a date series
I am unable to extend a date series, even using the Series menu itme under
Edit. It is not recognizing that the four dates I selected are a series. What is wrong? |
#2
|
|||
|
|||
Perhaps they're entered as Text, rather than XL dates.
In article , "Easydoesit" wrote: I am unable to extend a date series, even using the Series menu itme under Edit. It is not recognizing that the four dates I selected are a series. What is wrong? |
#3
|
|||
|
|||
No, I made sure it was in date format.
"JE McGimpsey" wrote in message ... Perhaps they're entered as Text, rather than XL dates. In article , "Easydoesit" wrote: I am unable to extend a date series, even using the Series menu itme under Edit. It is not recognizing that the four dates I selected are a series. What is wrong? |
#4
|
|||
|
|||
Then I can't think of why XL wouldn't extend the dates. Note that
setting the format does nothing if the entries have already been parsed as Text. In article , "Easydoesit" wrote: No, I made sure it was in date format. |
#5
|
|||
|
|||
Just because they are now formatted as dates doesn't mean that they
aren't text values. If you change the number format, does their appearance change? If not then you do still have text values in the cells. You can convert them to numerical values in a variety of ways. Since there are only 4 it's probably simplest to do F2, Enter in each of the cells. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |