Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

jrober

macrumors regular
Original poster
Jan 22, 2003
212
0
Heathfield, UK
All,

I am using a Powerbook G4 with 10.4.9 and running Microsoft Excel 11.3.3.

I have just opened a spreadsheet to find that all the dates now read 2010 instead of 2006 and they are 1 day out as well e.g. Tuesday 10th Oct 2006 now reads Monday 11th Oct 2010.

Q1 Anyone else find issues with recent upgrades e.g. 10.4.9 or MS security upgrades

Q2 Anyone know of a systematic way to sort these out? I have 200 different dates to correct!

Thanks in advance.

John

EDIT - All dates had 1462 added to them? Now fixed but don't know of problem source. This was not confined to one spreadsheet.
 
It's to do with the difference in the two different dates between Windows and Macs that Excel starts counting from. The Windows version starts from 1900 and the Mac version starts in 2004. They're a day out because of the leap year issues.

Under Calculation Preferences you can tell Excel to use 1904 dates or not. It may be that the recent update checked or unchecked it.

If you're using lots of spreadsheets started in Windows, I'd probably uncheck it.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.