> that the workbook you're in is employing the 1904 Date System which is the
> default in Mac Excel. Dates in Mac Excel [as well as most other Mac data
> management apps] actually are serial values offset from January 1, 1904.
>
> The the default in the Windows OS, however, is the 1900 Date System which
> offsets from January 1, 1900. The date system used in a workbook file is
> specific to that workbook, though, so regardless of what version of Excel
> you're using when you *open* a file created by any version of Excel the
> dates & calculations involving dates will be correct.
>
> What you've run into, however, is because of *copying* from a file based on
> one date system & pasting into a file based on the other date system. What
> actually gets copied is the serial value of the date. When that value gets
> pasted into a book using the other date system the dates rendered will be 4
> years & 1 day off � in what direction determined by the values copied.
>
> Volumes describing the issue as well as how to deal with the conflict
> readily can be found if you search the Web or the Microsoft site for 'Date
> System'... Or just start here:
>
>
http://support.microsoft.com/kb/214330/en-us?spid=2513&sid=global
>
> HTH |:>)
> Bob Jones
> [MVP] Office:Mac
>
>
>
>
> On 4/21/10 10:24 AM, in article (e-mail address removed)2ac0,
> "
[email protected]" wrote:
>
> > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> > When I enter a date in the format of MMM/YY it saves ok but if you then look
> > in tools and calculator I have found that it creates a formula of 2004 and
> > when you copy this over to a Windows based PC it displays incorrect dates. How
> > do I turn off this apparent formula creation. I live in UK and have settings
> > to UK
> Excellent thank you for such a superb solution.
>
