Excel Copying dates in Excel 2007

Joined
Sep 5, 2012
Messages
2
Reaction score
0
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!
 
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.
 
If you copy to the clipboard and select the destination cells, then hit enter, it should paste in all the selected cells.

Stoneboysteve
 
Back
Top