Excel Copying dates in Excel 2007

[Bruno2]

I'm trying to copy a date into successive cells in a column; re several entries happened on 07/08/2012. When I copy it it shows as 07/08/2013, 07/08/2014, etc in the successive cells? Help please!

 

[alow]

It's probably a formatting issue. You can try to clear all formatting from the cells prior to entering a date and filling the series. If it's not a formatting issue, after you fill the series down, click on the small button in the bottom right of the range with a plus sign that shows up. You should have the option to Fill Days.

 

[Stoneboysteve]

If you copy to the clipboard and select the destination cells, then hit enter, it should paste in all the selected cells.

Stoneboysteve

 

[Bruno2]

Thanks very much! The solutions given both worked.