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.