To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76942
------- Additional comments from [EMAIL PROTECTED] Fri May 4 14:52:01 +0000 2007 ------- oops, sorry, now i see you already submitted one. well, the function =YEAR(39000) returns an integer. in this case: 2007 now, when you format a cell with the value 2007 as a date format (like you did) you get odd results. in this case, the julian date 2007 returns a date in the year 1905. (aprox 2007 days after the start of year 1900) i close this issue for now, when you have further questions, please contact a forum for help. for example http://support.openoffice.org/index.html succes --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]