|Subject:||Problem with numbers not displayed correctly|
|Date:||Tue, 3 Mar 2009|
There is a problem with how numbers are displayed in my version of
excel 2007. When I copy formulas to new cells, numbers are not
displayed correctly (the stored values seem to be correct, though).
A1 = 1
A2 = 5
A3 = 1000
If I set cell B1=A2/A1, the value 5 is shown (correct). If I copy this
formula to cell B2, which yields B2=A3/A2, the value 5 is shown
(incorrect). In fact, when I copy formulas to new cells, the formulas
are updated as they should, but the number of the new cell is always
displayed as the number of the original cell.
The problem does not occur if I type in the formulas manually, only
when I copy formulas.
Has anyone else experienced this or know how it can be solved?
Any help will be greatly appreciated.