can't extend a date series

E

Easydoesit

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.
 
G

Gord Dibben

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
 
Top