formula results into zero

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jomni - 31 Mar 2004 04:07 GMT

My officemate has experienced the following:

When she adds two cells, the result shown in the cell is zero.
But when you press F2 you can see the correct result.
What is the cause of this? Even changing the cell format does not
work.

The file size is actually about 6MB... maybe that has something to do
about it.:confused:

---
Message posted from http://www.ExcelForum.com/

Reply to this Message

Dave Hawley - 31 Mar 2004 04:21 GMT

Hi

Can you post the formula that is being used and the values of the
referenced cells? Pushing F2, while in the cell, should only put you
into Edit Mode and show the Formula, not the result.

Reply to this Message

jomni - 31 Mar 2004 04:34 GMT

It's just a simple addition. Cell1 + Cell2. I'm wrong about pressin
F2. It's actually meant pressing F2 then F9. Anyway it's probably
circular reference. Thanks anyway

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Bernard V Liengme - 31 Mar 2004 16:00 GMT

If you press F9 while in Edit mode, Excel performs the calculation and saves
the numeric result. To avoid this, after pressing F9, tap the ESC key.
Best wishes Bernard

> It's just a simple addition. Cell1 + Cell2. I'm wrong about pressing
> F2. It's actually meant pressing F2 then F9. Anyway it's probably a
> circular reference. Thanks anyway.
>
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message