Dragging without incrementing

[Gianni]

I have a column of cell with the date, e.g.,

08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10

Is there some way of doing this?

 

[Jim Cone]

1. Copy the cell, select the destination cells, paste.
-or-
2. Change the number format of the original cell to text.
Drag and fill.
Change the number format, for all cells, to date.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware

..
..
..

"Gianni" <[email protected]>
wrote in message
I have a column of cell with the date, e.g.,

08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10
Is there some way of doing this?

 

[Claus Busch]

Hi Gianni,

Am Sat, 21 Aug 2010 10:45:58 -0400 schrieb Gianni:

08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10

press CRTL and drag down.


Regards
Claus Busch

 

[Gianni]

1. Copy the cell, select the destination cells, paste.
-or-
2. Change the number format of the original cell to text.
Drag and fill.
Change the number format, for all cells, to date.

Copy and Paste works.

If I change the column to Text
08/21/10 becomes 40411.

It is already Date format.

I tried creating a column from scratch
that was text and entered

08/21/10

and when I dragged it, it became

08/21/11

Copy and Paste seems to be the only
thing that works.

Thanks for answering.

 

[Gianni]

Hi Gianni,

Am Sat, 21 Aug 2010 10:45:58 -0400 schrieb Gianni:


press CRTL and drag down.


Regards
Claus Busch

Yes. That works nicely.

Danke

 

[Dave Peterson]

I rightclick on that autofill button and drag down. Then when I release the
mouse, I get a prompt asking me how I want to fill in the range.

For me, it's easier than remembering what those control-keys do.

 

[Stan Brown]

I have a column of cell with the date, e.g.,

08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10

Is there some way of doing this?

What I usually do is type the value in the first of the destination
cells, so I then have two cells together with the same value. I
highlight both, and click and drag. Excel seems to know that the
increment is zero since the two source cells are identical.

There's probably a more elegant way, but this WFM.