Extending a date series

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Easydoesit - 23 Feb 2005 17:42 GMT

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?

Reply to this Message

JE McGimpsey - 23 Feb 2005 17:53 GMT

Perhaps they're entered as Text, rather than XL dates.

> 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?

Reply to this Message

Easydoesit - 23 Feb 2005 18:07 GMT

No, I made sure it was in date format.

> Perhaps they're entered as Text, rather than XL dates.
>
>> 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?

Reply to this Message

JE McGimpsey - 23 Feb 2005 19:47 GMT

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.

> No, I made sure it was in date format.

Reply to this Message

Bill Manville - 23 Feb 2005 23:44 GMT

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 to this Message