Excel Integers appear as decimal fractions

[DrJ]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I enter a number (integer) into a cell in a new spreadsheet or one formatted as anything but percentage, it appears as a decimal fraction of that number; i.e., enter "1," appears as "0.01." Nothing in the preferences works, nor does changing the cell format.
Mac OS X 10.5.6/Mac Intel/Excel 2008

 

[CyberTaz]

Yes, something in the Preferences *does* work

In Excel> Preferences> Edit, clear the check on "Display this number of
decimal places". You'll have to re-enter any existing data or:

Enter 100 into a cell & Copy,
Select any cells to be changed & use Edit> Paste Special> Multiply

HTH |:>)
Bob Jones
[MVP] Office:Mac