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?

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?

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?

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.

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