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.