can't extend a date series

I am unable to get Excel to recognize or extend a series of dates. I
formatted the column as dates (2/23/2005 format), but all the extension does
is to copy the first date in the list into all the subsequent cells.

Easy

Excel is treating that date entry as text.

Enter the first date as 23/2/2005 then drag/copy down.

Now format the column to Custom mm/dd/yyyy


Gord Dibben Excel MVP


On Wed, 23 Feb 2005 11:19:45 -0700, "Easydoesit" <[email protected]>
wrote:

>I am unable to get Excel to recognize or extend a series of dates. I
>formatted the column as dates (2/23/2005 format), but all the extension does
>is to copy the first date in the list into all the subsequent cells.
>