Prev: Linking sheets which must update the date first Excel 2007
Next: ***Conditional Formatting Multiple Cells***
From: rkoett on 17 May 2010 17:08
I'm trying to use the fill handle to fill a series of dates one day at a
time. The cells are formatted as dates, and the first few are filled like
this:
May-17-2010
May-18-2010
May-19-2010
If I select the first cell and drag the fill handle down, I get:
May-17-2010
May-17-2011
May-17-2012
If I select the first three cells and drag the fill handle down, I get:
May-17-2010
May-18-2010
May-19-2010
May-17-2011
May-18-2011
May-19-2011
What I want is to get this:
May-17-2010
May-18-2010
May-19-2010
May-20-2010
May-21-2010
May-22-2010
I've tried dragging the fill handle with the right mouse button, but the
menu options that appear for "Fill Days", "Fill Weekdays", "Fill Months", and
"Fill Years" are all grayed out.
This is Excel 2010, in case that matters. How can I make this work?
Thanks,
Richard Koett.
From: RagDyer on 17 May 2010 19:44
Your data is *TEXT*, not XL recognized numbers (dates)!

Enter a default date format such as:
5/17/10

Then, click back in that cell, and Custom Format to:
mmmm-dd-yyyy

That will give you the format you're looking for.

Now, drag that cell down to get what you want.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rkoett" <rkoett(a)newsgroup.nospam> wrote in message
news:E15311A3-F0EE-45F6-84F7-9F97FCC77E23(a)microsoft.com...
> I'm trying to use the fill handle to fill a series of dates one day at a
> time. The cells are formatted as dates, and the first few are filled like
> this:
> May-17-2010
> May-18-2010
> May-19-2010
> If I select the first cell and drag the fill handle down, I get:
> May-17-2010
> May-17-2011
> May-17-2012
> If I select the first three cells and drag the fill handle down, I get:
> May-17-2010
> May-18-2010
> May-19-2010
> May-17-2011
> May-18-2011
> May-19-2011
> What I want is to get this:
> May-17-2010
> May-18-2010
> May-19-2010
> May-20-2010
> May-21-2010
> May-22-2010
> I've tried dragging the fill handle with the right mouse button, but the
> menu options that appear for "Fill Days", "Fill Weekdays", "Fill Months",
> and
> "Fill Years" are all grayed out.
> This is Excel 2010, in case that matters. How can I make this work?
> Thanks,
> Richard Koett.


 | 
Pages: 1
Prev: Linking sheets which must update the date first Excel 2007
Next: ***Conditional Formatting Multiple Cells***