Fill Series  
Author Message
Jarrad





PostPosted: Mon Jul 23 16:40:07 CDT 2007 Top

worksheet functions >> Fill Series

Hi....

I'm not a newby to EXCEL but I'm having problems with my Cell fill...

I have a cell that is ex.:

Saturday, July 29, 2007

Everytime I try to extend the fill series...it does this fill:

Saturday, July 29, 2008
Saturday, July 29, 2009 ....and so on....

What I want isL:

Sunday, July 30, 2007
Monday, July 31, 2007 ....and so on....

Can anyone shed any light on my fudderery???? I would appreciate any help.

--
Thanx, Suz

Excel329  
 
 
Toppers





PostPosted: Mon Jul 23 16:40:07 CDT 2007 Top

worksheet functions >> Fill Series Set the first two cells to the desired dates , select them both and fill down.



> Hi....
>
> I'm not a newby to EXCEL but I'm having problems with my Cell fill...
>
> I have a cell that is ex.:
>
> Saturday, July 29, 2007
>
> Everytime I try to extend the fill series...it does this fill:
>
> Saturday, July 29, 2008
> Saturday, July 29, 2009 ....and so on....
>
> What I want isL:
>
> Sunday, July 30, 2007
> Monday, July 31, 2007 ....and so on....
>
> Can anyone shed any light on my fudderery???? I would appreciate any help.
>
> --
> Thanx, Suz
 
 
Gord





PostPosted: Mon Jul 23 18:07:33 CDT 2007 Top

worksheet functions >> Fill Series That's a workaround Toppers but.................

You should be able to fill series by dragging July 29, 2008 alone.

Don't understand why Excel changes the year unless July 29, 2007 is text to
start with.

In that case the 2007 would change to 2008 and so on.

Try Selecting the "date" and Data>Text to Columns>Delimited>Finish

Or Data>Text to Columns>Next>Next>Column Data Format>Date>MDY>Finish.


Gord Dibben MS Excel MVP





>Set the first two cells to the desired dates , select them both and fill down.
>

>
>> Hi....
>>
>> I'm not a newby to EXCEL but I'm having problems with my Cell fill...
>>
>> I have a cell that is ex.:
>>
>> Saturday, July 29, 2007
>>
>> Everytime I try to extend the fill series...it does this fill:
>>
>> Saturday, July 29, 2008
>> Saturday, July 29, 2009 ....and so on....
>>
>> What I want isL:
>>
>> Sunday, July 30, 2007
>> Monday, July 31, 2007 ....and so on....
>>
>> Can anyone shed any light on my fudderery???? I would appreciate any help.
>>
>> --
>> Thanx, Suz

 
 
Suzanne





PostPosted: Mon Jul 23 20:44:00 CDT 2007 Top

worksheet functions >> Fill Series Hi...Toppers and Gord....

Well....I tried both of your suggestions....and neither works. I made sure
my column was set to date and delimited. Any other hints???

--
Thanx, Suz




> Hi....
>
> I'm not a newby to EXCEL but I'm having problems with my Cell fill...
>
> I have a cell that is ex.:
>
> Saturday, July 29, 2007
>
> Everytime I try to extend the fill series...it does this fill:
>
> Saturday, July 29, 2008
> Saturday, July 29, 2009 ....and so on....
>
> What I want isL:
>
> Sunday, July 30, 2007
> Monday, July 31, 2007 ....and so on....
>
> Can anyone shed any light on my fudderery???? I would appreciate any help.
>
> --
> Thanx, Suz
 
 
Gord





PostPosted: Mon Jul 23 21:10:30 CDT 2007 Top

worksheet functions >> Fill Series Just formatting a text date to date will not do the trick. You have to force it
to become a number which is how Excel stores dates.

IMO you have a date July 29, 2007 that is text.

I am surprised the Text to Columns did not do the trick.

Try this................format to General.

Copy an empty cell.

Select the cell with the date and edit>paste special>add>ok>esc.

Re-format to date.

Now try your fill series.


Gord





>Hi...Toppers and Gord....
>
>Well....I tried both of your suggestions....and neither works. I made sure
>my column was set to date and delimited. Any other hints???

 
 
Suzanne





PostPosted: Tue Jul 24 12:16:03 CDT 2007 Top

worksheet functions >> Fill Series Good morning...Gord....

ACKKK!!! I cannot figure this one out....I tried everything you suggested
and the fill series still wants to keep everything the same but change the
year....is it because
I have the day of the week?????

Tuesday, July 24, 2007
the next becomes
Tuesday, July 24, 2008 ....and so on....

I just want it to become the next day as in:
Wednesday, July 25, 2007

I am just perplexed!

I will listen to anything you can come up with....

Thanx again,

Suzanne
--
Thanx, Suz




> Just formatting a text date to date will not do the trick. You have to force it
> to become a number which is how Excel stores dates.
>
> IMO you have a date July 29, 2007 that is text.
>
> I am surprised the Text to Columns did not do the trick.
>
> Try this................format to General.
>
> Copy an empty cell.
>
> Select the cell with the date and edit>paste special>add>ok>esc.
>
> Re-format to date.
>
> Now try your fill series.
>
>
> Gord
>
>


>
> >Hi...Toppers and Gord....
> >
> >Well....I tried both of your suggestions....and neither works. I made sure
> >my column was set to date and delimited. Any other hints???
>
>
 
 
Beege





PostPosted: Tue Jul 24 12:26:13 CDT 2007 Top

worksheet functions >> Fill Series
> Good morning...Gord....
>
> ACKKK!!! I cannot figure this one out....I tried everything you suggested
> and the fill series still wants to keep everything the same but change the
> year....is it because
> I have the day of the week?????
>
> Tuesday, July 24, 2007
> the next becomes
> Tuesday, July 24, 2008 ....and so on....
>
> I just want it to become the next day as in:
> Wednesday, July 25, 2007
>
> I am just perplexed!
>
> I will listen to anything you can come up with....
>
> Thanx again,
>
> Suzanne

Suzanne,

If you format cells with the date (use format"dddd, mmmm d, yyyy", and
put in 7/24/07, you should see "Tuesday, July 24, 2007". Yes? But if you
type in General format "Tuesday, July 24, 2007" it comes out as text.
and the year indexes as you fill the series. Do it the first way, and
the day indexes as you fill it. That's how it works for me, anyways...

Beege
 
 
Peo





PostPosted: Tue Jul 24 12:24:24 CDT 2007 Top

worksheet functions >> Fill Series It's because the dates are text, text values with numbers in them will fill
the number part at the end which it does since the year changes. Do you
type these in? If so the date format is wrong.
It's best to enter a date like

07/24/07

then use a custom format of

dddd, mmmm dd, yyyy

then copy down and it will change the way you want, I doubt you can ever
type in

Tuesday, July 24, 2007

and get Excel to recognize it as a date


--
Regards,

Peo Sjoblom





> Good morning...Gord....
>
> ACKKK!!! I cannot figure this one out....I tried everything you suggested
> and the fill series still wants to keep everything the same but change the
> year....is it because
> I have the day of the week?????
>
> Tuesday, July 24, 2007
> the next becomes
> Tuesday, July 24, 2008 ....and so on....
>
> I just want it to become the next day as in:
> Wednesday, July 25, 2007
>
> I am just perplexed!
>
> I will listen to anything you can come up with....
>
> Thanx again,
>
> Suzanne
> --
> Thanx, Suz
>
>

>
>> Just formatting a text date to date will not do the trick. You have to
>> force it
>> to become a number which is how Excel stores dates.
>>
>> IMO you have a date July 29, 2007 that is text.
>>
>> I am surprised the Text to Columns did not do the trick.
>>
>> Try this................format to General.
>>
>> Copy an empty cell.
>>
>> Select the cell with the date and edit>paste special>add>ok>esc.
>>
>> Re-format to date.
>>
>> Now try your fill series.
>>
>>
>> Gord
>>
>>
>> On Mon, 23 Jul 2007 18:44:00 -0700, Suzanne


>>
>> >Hi...Toppers and Gord....
>> >
>> >Well....I tried both of your suggestions....and neither works. I made
>> >sure
>> >my column was set to date and delimited. Any other hints???
>>
>>


 
 
Suzanne





PostPosted: Tue Jul 24 12:50:04 CDT 2007 Top

worksheet functions >> Fill Series OMG

THANK YOU ....ALL for your help....duh...duh...duh...I finally got it! It's
beautiful!

Thank you, Toppers, Gord, Peo and Beege.....yeah yeah yeahhhhh!

Suzanne
--
Thanx, Suz





> > Good morning...Gord....
> >
> > ACKKK!!! I cannot figure this one out....I tried everything you suggested
> > and the fill series still wants to keep everything the same but change the
> > year....is it because
> > I have the day of the week?????
> >
> > Tuesday, July 24, 2007
> > the next becomes
> > Tuesday, July 24, 2008 ....and so on....
> >
> > I just want it to become the next day as in:
> > Wednesday, July 25, 2007
> >
> > I am just perplexed!
> >
> > I will listen to anything you can come up with....
> >
> > Thanx again,
> >
> > Suzanne
>
> Suzanne,
>
> If you format cells with the date (use format"dddd, mmmm d, yyyy", and
> put in 7/24/07, you should see "Tuesday, July 24, 2007". Yes? But if you
> type in General format "Tuesday, July 24, 2007" it comes out as text.
> and the year indexes as you fill the series. Do it the first way, and
> the day indexes as you fill it. That's how it works for me, anyways...
>
> Beege
>