A workbook was created on Mac but is now used on a PC. I had the date
conversion fixed and now suddenly its gone crazy. All the spread sheets read
incorrect dates, The only way I was able to fix part of the problem was
nder tools, options, calculations and it now shows 1904. However, one page
in the workbook is still showing 5 digit date "39744". When I use the 1492 #
and try to subtract its still off by 4 years and 1 day, if I add, its off by
8 years, 1 mo. 1 day. Please help. I can't do any updates till this is
resolved. I am currently using Office 2003.