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?

Try this link for answers to both of your questions: http://support.microsoft.com/kb/214330

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

thanks, that's just what I needed -- I can't believe I haven't run into this problem before!

Ask Your Question

Weekly Poll