Numbers dont display or add up correctly in excel

[Clive]

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

I type in 1000 and it divides all numbers by 100, 23 becomes 0,23.

Then if I Sum a list of numbers it doesn't ad up coretly (even the wrong numbers don't add up)

Excel doesn't work for me - although the product was provided (bundled) by Apple - apple won't support it - and neither will Microsoft so I end up with no-person to talk to - amazing.

Any help from anyone would be appreciated.

Thanks

 

[Bob Greenblatt]

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

I type in 1000 and it divides all numbers by 100, 23 becomes 0,23.

Then if I Sum a list of numbers it doesn't ad up coretly (even the wrong
numbers don't add up)

Excel doesn't work for me - although the product was provided (bundled) by
Apple - apple won't support it - and neither will Microsoft so I end up with
no-person to talk to - amazing.

Any help from anyone would be appreciated.

Thanks

Go to Excel preferences, Edit tab and uncheck "display this many decimal
places."