Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Help with excel sheet copy question please
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="nabl" data-source="post: 980458" data-attributes="member: 43512"><p>Excel stores dates internally as the number of days since a base date. The problem for you is that the base date is different between the Windows and Mac versions of Excel: on Windows, the base date is January 1, 1900, while on Macs it's January 2, 1904. So what's happening is that the same number of days is being counted, but it's being added to a different date. You can read more about it in Excel's documentation for the DATE function.</p><p></p><p>To fix it (on a per-workbook basis), choose Excel > Preferences from the menu bar and then click the Calculation section. Uncheck the Use the 1904 date system option and you should be good to go; just keep it in mind when using dates and transferring files between Windows and Mac users.</p></blockquote><p></p>
[QUOTE="nabl, post: 980458, member: 43512"] Excel stores dates internally as the number of days since a base date. The problem for you is that the base date is different between the Windows and Mac versions of Excel: on Windows, the base date is January 1, 1900, while on Macs it's January 2, 1904. So what's happening is that the same number of days is being counted, but it's being added to a different date. You can read more about it in Excel's documentation for the DATE function. To fix it (on a per-workbook basis), choose Excel > Preferences from the menu bar and then click the Calculation section. Uncheck the Use the 1904 date system option and you should be good to go; just keep it in mind when using dates and transferring files between Windows and Mac users. [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Help with excel sheet copy question please
Top