Solved Excel changing dates when copying cells (Mac)

March 29, 2012 at 09:57:24
Specs: Macintosh
When I copied a range of date cells and pasted them into a new workbook, the dates changed by 4 years and 1 day. I found a solution on this site (posted by DerbyDad03) to change the date system, but I can't figure out how to do it in my version of Excel (Excel 2008 for Mac). Also, if the original workbook has the funky date system, how would I convert the dates to avoid this problem in the future?

See More: Excel changing dates when copying cells (Mac)

Report •

#1
March 29, 2012 at 10:57:42
✔ Best Answer

Report •

#2
March 29, 2012 at 14:32:37
thanks, that's just what I needed -- I can't believe I haven't run into this problem before!

Report •
Related Solutions


Ask Question