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!
 

alow

Excel Formulator
Joined
Mar 20, 2012
Messages
763
Reaction score
4
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.
 
Ad

Advertisements

Joined
Sep 3, 2008
Messages
163
Reaction score
5
If you copy to the clipboard and select the destination cells, then hit enter, it should paste in all the selected cells.

Stoneboysteve
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top