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.
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" <davehumphrey2@home.com>
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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks