Re: Cell reference in formula always returns a zero value

Tech-Archive recommends: Fix windows errors by optimizing your registry

Gord:

Thanks for your suggestions. However, nothing shows up as an issue in
either code view.

In my simple example, the 6 was keyed into A1.

It appears that something has failed within Excel. I can no longer
create a formula with a cell reference and have the value of that cell
returned to the formula. Also, existing formulae will no longer update
when the value of a referenced cell is changed.

It looks like I will need to reload Excel.



Gord Dibben wrote:
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 *** that is changing the 6 in A2 to
a zero?

Right-click on *** tab and "View Code"

Anything there that could be doing the deed?

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

Anything there?


Gord Dibben MS Excel MVP

On 27 Nov 2006 16:58:35 -0800, "Jim Alderman" <jim.alderman@xxxxxxxx> 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.

.

Quantcast