Excel 08 divides numbers by 100

[chinook]

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

I have been a longtime PC excel user and have recently switched to MAC. For some reason, although I've formatted cells as numbers, every time I enter a number in a cell, it is automatically divided by 100. The only way around this is to put an = sign in front of the number.

 

[CyberTaz]

Head into Excel> Preferences> Edit & clear the check on "Display this number
of decimal places".

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

 

[chinook]

Thanks. That did it.