Gord:

After further testing I have found that the problem is simply that
formulae no longer work. A formula of =1+1 displays a value of 0. It
appears that my Excel installation is hosed.


Jim Alderman wrote:
Gord:

Yes, I am set to automatic.


Gord Dibben wrote:
Jim

ToolsOptionsCalculation.

Are you set to "Automatic"?


Gord

On 27 Nov 2006 17:21:20 -0800, "Jim Alderman" wrote:

No, A1 is numeric. I created the simple example for the ease of
discussion. I have existing spreadsheets with elaborate formulae that
used to work fine. Now they all fail. Cells that contain a formula
display the value of the formula before my issue began. If I go to one
of the referenced cells and change its value, the formula cell still
shows the original value. Go figure - I have no idea what is going
on here.


David Biddulph wrote:
I would guess that A1 contains text, rather than the number 6. Look in the
formula box when A1 is selected, and see whether you've got any leading or
trailing spaces or other characters.
--
David Biddulph

"Jim Alderman" wrote in message
ups.com...
Example:

Cell A1 contains the number 6.
Cell A2 contains the formula =A1 but displays a value of 0.

The calculation option is set to Automatic.

What has gone wrong? I am obvious missing something here.


Gord Dibben MS Excel MVP