Bug in Excel 2008

Discussion in 'OS X and OS X Apps' started by coolpix32, Aug 5, 2008.

  1. coolpix32

    coolpix32 Active Member

    Joined:
    Nov 2, 2007
    Messages:
    965
    Likes Received:
    58
    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?
     
  2. booblanco

    booblanco Active Member

    Joined:
    Mar 29, 2005
    Messages:
    5,485
    Likes Received:
    0
    Location:
    Paranaque
    sometimes i'm unable to save a file or plot a graph because of 'insufficient memory'
     
  3. bacchus_3

    bacchus_3 PhilMUG Addict Member

    Joined:
    Apr 29, 2007
    Messages:
    4,804
    Likes Received:
    310
    Gender:
    Male
    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.
     
  4. theelhombre

    theelhombre Member

    Joined:
    Oct 9, 2007
    Messages:
    473
    Likes Received:
    0
    i've got no problems with mine.
     
  5. raypin

    raypin PhilMUG Addict Member

    Joined:
    Jun 8, 2008
    Messages:
    14,484
    Likes Received:
    7,671
    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?
     
    #5 raypin, Aug 5, 2008
    Last edited: Aug 5, 2008
  6. machazel

    machazel Member

    Joined:
    Nov 28, 2005
    Messages:
    669
    Likes Received:
    0
    No problems with mine either.it could be what raypin said.
     
    #6 machazel, Aug 5, 2008
    Last edited: Aug 5, 2008
  7. coolpix32

    coolpix32 Active Member

    Joined:
    Nov 2, 2007
    Messages:
    965
    Likes Received:
    58
    @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. :)
     
  8. coolpix32

    coolpix32 Active Member

    Joined:
    Nov 2, 2007
    Messages:
    965
    Likes Received:
    58
    checked my settings and it's set to Philippines. could this be it?

    i've also reformatted my spreadsheet to my personal preference.
     
  9. raypin

    raypin PhilMUG Addict Member

    Joined:
    Jun 8, 2008
    Messages:
    14,484
    Likes Received:
    7,671
    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.
     
    #9 raypin, Aug 5, 2008
    Last edited: Aug 5, 2008

Share This Page

  • About PhilMUG

    Since the mid-1990s, PhilMUG (formerly the Philippine Macintosh Users Group) has grown to become not just the Philippines’ but one of the world’s foremost Apple user groups. Our online community brings together thousands of members from the Philippines and around the world for the latest news and discussions covering all Apple products and related hardware and software. Anyone can join PhilMUG, from newbies to experts, subject to our membership rules and guidelines.
  • Like us on Facebook

  • Buy us a beer!

    The staff works very hard to make sure that PhilMUG is running 24/7. Care to buy us a beer or help out with our hosting fees? We'd really appreciate it!

    Donate to us!