C
Clive
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Firstly I have used Excel for many years without this problem ever surfacing!
The problem is that when I SUM a column of numbers the results aren't correct so clearly all the numbers aren't being added up - even though the formula is correct.
Additionally on some cells where I am doing a very simple 'take one number from another number' type of calculation - all that is returned in the cell is VALUE! and not the correct result. Clearly a setting isn't correct - but which one?
Any assistance would be greatly appreciated.
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Firstly I have used Excel for many years without this problem ever surfacing!
The problem is that when I SUM a column of numbers the results aren't correct so clearly all the numbers aren't being added up - even though the formula is correct.
Additionally on some cells where I am doing a very simple 'take one number from another number' type of calculation - all that is returned in the cell is VALUE! and not the correct result. Clearly a setting isn't correct - but which one?
Any assistance would be greatly appreciated.