New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Need help MS Office 2011 -Lion


Post Reply New Thread Subscribe

 
Thread Tools
kcnemo

 
Member Since: Jul 09, 2011
Posts: 42
kcnemo is on a distinguished road

kcnemo is offline
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.
QUOTE Thanks
EvenStranger

 
EvenStranger's Avatar
 
Member Since: Dec 09, 2010
Location: Virginia
Posts: 845
EvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really nice
Mac Specs: Currently 13" Late 2010 MBA, 4GB/128GB; Early 2011 13" MBP, dual core i7 2.7ghz, 4gb ram, 500gb hd

EvenStranger is offline
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.
QUOTE Thanks
kcnemo

 
Member Since: Jul 09, 2011
Posts: 42
kcnemo is on a distinguished road

kcnemo is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Firefox taking over CPU and very slow. | Mail problem »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
MAC Office 2011 Removal/Re-Install Koyangie OS X - Apps and Games 7 08-01-2011 04:59 PM
More news on Office for Mac 2011 and Mac OS X 10.7 Lion OneMoreThing... Apple Rumors and Reports 3 07-28-2011 01:52 AM
Microsoft reveals Office for Mac 2011 will be 32-bit only the8thark Apple Rumors and Reports 7 06-11-2010 03:35 PM
Road to Microsoft Office 2011 for Mac: A New Hope the8thark Apple Rumors and Reports 5 05-03-2010 12:54 AM

All times are GMT -4. The time now is 08:49 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?