Problem with numbers not displayed correctly

Giganews Newsgroups
Subject: Problem with numbers not displayed correctly
Posted by:  ander…@live.com
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).
For example:

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.

Replies