I know some trading applications use Excel so I thought I would post this here for the benefit of those who use it.
Excel 2010 is available in the x64 flavor. What this does is lift (remove) the former limit of 2GB ram allocation for the program.
This 2010 x64 version rocks. It's lightning fast.
The following occurs in Excel 2007 and 2010:
In cell A1 enter: .011
In cell A2 enter: -.01
In cell A3 click AutoSum
The correct answer is: .001
Select all 3 cells, right-click and select Format Cells..., select Number, and change Decimal places to 30.
This error occurs if you change Category to âCurrencyâ, âAccountingâ, âPercentageâ and âScientificâ. :eek:
Now, in cell A1 enter: 1000.1
In cell A2 enter: -1000
Poor cell A3 just can't handle basic subtraction.