And

Thanks for the thought, but there is no custom format. All formulae
are failing, both in existing spreadsheets and new ones. When you open
a new spreadsheet and type =1+1 into A1 and it displays 0, Excel must
certainly have experienced some type of corruption.

Jim

Andre Croteau wrote:
Jim,
Is it possible the the cell A2 has a custom format "0" (0 must be in
quotes)?
rgds

André


"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.