MacResource
Excel question - Printable Version

+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Excel question (/showthread.php?tid=54901)



Excel question - Ironhorse - 05-14-2008

I am trying to copy and paste from one workbook to another. When I paste to the new workbook it adds one day and 4 years to the new cells. Even tried to copy and move a tab and same thing happens.

Thanks

Dennis


Re: Excel question - Don C - 05-14-2008

In the preferences/calculation be sure that the "1904 date system" is the same on both workbooks (either both checked or both unchecked).


Re: Excel question - Ironhorse - 05-14-2008

Thanks more than you know that did the trick