Hi guys! I've noticed a bug in Excel for Mac 2008. I have a spreadsheet which has a column on dates that I keep track of. I am just puzzled why (and this happened a second time now) when I open this spreadsheet, the dates are changed. Examples: date: 01-Aug-08 was changed to 28-Jul-08 | date: 08-Aug-08 was changed to 05-Aug-04 (note the movement of the date and year). I am very sure of the dates I entered, as before saving it the last time, I double/triple checked it. Anyone encountered the same problem?
Do you happen to use this spreadsheet on both Windows and Mac? When my MB was fresh with a trial version of MS Office for Mac, it has always shown this prompt when I save my excel spreadsheets about difference of storing dates between the Mac and Windows version.
No problems with my excel for mac. Could it be a system preferences > international > format settings conflict problem? Mine is set U.S. to mirror our usual date format of month,day,year instead of European. Have you reformated the date field of your spreadsheet column to reflect your personal preference, just to be sure?
@bacchus_3 - I only use my Excel files on my Mac. Never opened it in Windows. @raypin & machazel - Thanks for your suggestions. This is very weird behavior if I'm the only one who encounters this. I'll check my settings.
checked my settings and it's set to Philippines. could this be it? i've also reformatted my spreadsheet to my personal preference.
suggest you open a new spreadsheet and transfer your data except for the dates column. Now comes the tedious part. Format the cells to mm/dd/yyyy and input your dates again one by one and see what happens. I juggle my excel files from mac to windows to pda and in some cases, even opened it using openoffice. No problems with the dates.