date format YYYY-MM-DD fill handle excel 2007

i have data in the format YYYY-MM-DD  (a custom date format). When I try to create further dates in sequence using the fill handle, for example creating values 2009-06-30 to 2009-07-01 the auto fill handle sequencing does not work as it produces 2009-06-31,2009-06-32 etc...

any suggestions?
gerrymac1943Asked:
Who is Participating?
 
cyberkiwiConnect With a Mentor Commented:
What you have is actually TEXT that looks like a date and to you represents a date.
Enter in a fresh cell somewhere the date "6/30/2009" without quotes.
Use cell formatting to change the DISPLAY format to yyyy-mm-dd.
Now use the fill handle - it will behave correctly.
0
 
Bordeaux0113Connect With a Mentor Commented:
Click format, cells, number tab, click date and select the type you want.
Then it should work just fine :)
0
 
gerrymac1943Author Commented:
great thanks
0
 
Bordeaux0113Commented:
No problem Good luck :)
0
All Courses

From novice to tech pro — start learning today.