Bug in Excel

[Bill Socks]

This is the strangest bug..... I have a column of dates in one spread
sheet and copy and paste them to a different sheet and the dates change
by 4 years and 1 day,,,,,, 03/05/04 -> 03/04/00 Where can this be
reported????

 

[Peo Sjoblom]

Not a bug, Excel Windows default date system starts January 0, 1900, Mac
Excel default starts January 1 1904,
meaning if you have a spreadsheet created with one or the other there will
be a difference of 1462 days.
You can set that in Mac under Preferences>Calculation, under Windows
Tools>Options>Calculation. You can select which system to use and if you
need to convert either add or subtract
1462, put 1462 in an empty cell and copy it, select the dates and do
edit>paste special and select add or subtract depending on where you
are coming from.

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Paul Berkowitz]

This is the strangest bug..... I have a column of dates in one spread
sheet and copy and paste them to a different sheet and the dates change
by 4 years and 1 day,,,,,, 03/05/04 -> 03/04/00 Where can this be
reported????

In your diary. Go to Excel/Preferences/Calculation.

In Workbook options, make sure both Workbooks have the same setting for
"1904 date system". In Excel Mac, that checkbox is checked by default, but
for workbooks originating on Windows it will be unchecked. (On Windows, the
1900 date system is used.)

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.