- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2009 March
- Problem with numbers not displayed correctly

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.

- Re: Problem with numbers not displayed correctly posted by Bernard Liengme on Tue, 3 Mar 2009
- RE: Problem with numbers not displayed correctly posted by Shane Devenshire on Tue, 3 Mar 2009