Results 1 to 3 of 3
  1. #1


    Member Since
    Jul 09, 2011
    Posts
    44
    Need help MS Office 2011 -Lion
    Wish it worked like Office '97.
    In Excel, I have a spreadsheet with bank account numbers, 14 digits. I keep trying to format as General, as Excel wants them in Scientific. Any way to correct?
    In Word, The Auto fill for today's date is September 23, 11. How do I change that so the default is September 23, 2011? Used multiple versions of Word and never saw the year displayed like that.

  2. #2

    EvenStranger's Avatar
    Member Since
    Dec 09, 2010
    Location
    Virginia
    Posts
    844
    Specs:
    Currently 13" Late 2010 MBA, 4GB/128GB; Early 2011 13" MBP, dual core i7 2.7ghz, 4gb ram, 500gb hd
    The two digit year was just mentioned by someone else this week. There's a MS knowledge base article about it. I've spoken to our Technical Accounts Manager from MS, and they are aware of the issue, but no ETA of when it might be addressed, or how to work around it, apart from entering the date manually.

    For the 14-digit number, set it to "Number" rather than "General." Even "Text" will convert it into scientific notation for some strange reason. Maybe if the cell was made Text first, it would hold.

  3. #3


    Member Since
    Jul 09, 2011
    Posts
    44
    Thanks for the reply
    Quote Originally Posted by EvenStranger View Post
    The two digit year was just mentioned by someone else this week. There's a MS knowledge base article about it. I've spoken to our Technical Accounts Manager from MS, and they are aware of the issue, but no ETA of when it might be addressed, or how to work around it, apart from entering the date manually.

    For the 14-digit number, set it to "Number" rather than "General." Even "Text" will convert it into scientific notation for some strange reason. Maybe if the cell was made Text first, it would hold.
    Thank you,
    Seems somedays, no matter how much you search, you don't see those earlier posts. Sometimes, it's all in how you ask the question.
    Problem, it was a Office 97 spreadsheet being used in Open Office. I waited for Lion to get a new Mac and just imported the spreadsheet. Too much to reformat. At least MS finally lets you have spreadsheets with several 100K of lines. Used to have to use Quattro Pro.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mountain Lion with Office 2011 - Powerpoint issues
    By greid in forum OS X - Operating System
    Replies: 0
    Last Post: 09-28-2012, 03:27 PM
  2. uninstall Office 2011 for Lion OS
    By emanthemacman in forum OS X - Operating System
    Replies: 2
    Last Post: 06-20-2012, 10:44 AM
  3. OSX Lion & Office for Mac 2011 go slow
    By yookay in forum OS X - Operating System
    Replies: 5
    Last Post: 01-09-2012, 05:07 PM
  4. Will Office 2011 work on Lion?
    By 2b2cool in forum OS X - Operating System
    Replies: 8
    Last Post: 07-23-2011, 03:52 PM
  5. Lion and office 2011 compatibility
    By venud in forum OS X - Operating System
    Replies: 3
    Last Post: 05-09-2011, 06:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •