Jim

=A1 will return whatever is in A1 whether it is text or numeric.

If it shows a zero something else is going on.

How does the 6 get entered to A1.....manually or by formula?

Do you have any helpful event code in the sheet that is changing the 6 in A2 to
a zero?

Right-click on sheet tab and "View Code"

Anything there that could be doing the deed?

Right-click on the Excel logo at left of File on the worksheet menubar and
select "View Code".

Anything there?


Gord Dibben MS Excel MVP

On 27 Nov 2006 16:58:35 -0800, "Jim Alderman" wrote:

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.