can't extend a date series

  • Thread starter Thread starter Easydoesit
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enter start and end date/time in excel based on some specific value. 7
Series fill only copying and fill series greyed out 1
Number series at end of column macro? 4
date format in excel imported from an SQL DB. 2
I copied Visible Cells Only, but it pastes only the first cell 1
converting text to proper dates 6
How do I auto fill a date series 2
excel does not recognize dates 2

Back
Top