Excel devides figures on entry

[deerpath]

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

Suddenly my Excel is dividing anything that you type into a cell by 10. Can't seem to figure out how to fix or how it happened. Anyone know the answer?

 

[CyberTaz]

In Deed! And posted numerous times

Excel> Preferences> Edit -- clear the check on "Display this number of
decimal places:" to prevent it form continuing.

Alternatively, you can leave the pref on & type a decimal point following
whole numbers in order to override the setting when necessary.

Note: Even if you turn the pref off it will not change content which had
previously been entered. You'll need to re-enter or;

Type 10 into any empty cell & copy,
Select the cells which were affected,
Use Edit> Paste Special - Multiply to convert them

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

 

[deerpath]

Thank you for the help! That did the trick, much appreciated.

In Deed! And posted numerous times