Copying Dates Question

[Von Fourche]

I'm new to Excel and have a question.

I can type in a date like this: 3-mar-09. Ok, then I can click the
corner of the cell and copy that date to cell under that cell. However, it
add a day and becomes: 4-mar-09.

Is there any way to turn that off so I can type 3-mar-09 and copy that
cell exactly like that without excel adding days?

Thanks!

 

[Kassie]

To keep the same date, you will have to:
Use <Ctrl><C> and <Ctrl><V>; or
enter it in two cells directly below each other, say A1:A2. Now select both
cells, and then drag down as far as you want.

--
HTH

Kassie

Replace xxx with hotmail

 

[Von Fourche]

To keep the same date, you will have to:
Use <Ctrl><C> and <Ctrl><V>; or
enter it in two cells directly below each other, say A1:A2. Now select
both
cells, and then drag down as far as you want.

Nice. Thanks.

 

[Gord Dibben]

Enter the date in A1

Right-click on the fill handle and drag dowm.

Release and "Copy Cells"


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Try right-click and drag, Kassie

A couple of steps easier.


Gord Dibben MS Excel MVP

 

[Kassie]

Thanks gord, you see, you are never too old to learn something new!

--
HTH

Kassie

Replace xxx with hotmail

 

[Gord Dibben]

Every day I learn something new and I'm getting pretty long in the tooth<g>

These news groups are great.


Gord