Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Numbers are automatically divided by 100 and I can't turn it off

74 views
Skip to first unread message

hati...@officeformac.com

unread,
Feb 18, 2010, 11:56:47 AM2/18/10
to
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi there
I really need help. I spent hours trying to stop excel to divide all numbers I enter anywhere in the sheet by 100. It doesn't matter if it is a new sheet I just opened or an old one. And I tried to format the cells differently, but nothing worked.
Can anybody help?
Thanks a lot
Lena

simran

unread,
Feb 18, 2010, 1:34:30 PM2/18/10
to

Mike Middleton

unread,
Feb 18, 2010, 4:36:33 PM2/18/10
to
Lena or hatifant  -
 
Excel > Preferences > Edit > uncheck "Display this number of decimal places" > OK
 
-  Mike
 

hati...@officeformac.com

unread,
Feb 19, 2010, 2:09:03 AM2/19/10
to
No, 3400 would appear as 34.
0 new messages