Enter the date in A1

Right-click on the fill handle and drag dowm.

Release and "Copy Cells"


Gord Dibben MS Excel MVP

On Sat, 5 Sep 2009 02:48:25 -0400, "Von Fourche"
wrote:



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!