Excel Calculation Result Display Failure

[guy.yeon]

Hi,

A simple calculation formula result is not displayed correctly.

Formula: "=3+3"
Expected result: 6
Displayed result: 0

This failure occurs only in one particular sheet among all the sheets
of a workbook.
If I select the formula from the formula bar and click F9, I can see
number 6.
But once I come out of the cell by clicking ESC button, the formula
displays number 0.

Several trials have been made to get the expected result.

Trial 1: Tools >> Option >> Automatic (calculation option) selected
Trial 2: F9 key clicked
Trial 3: Ctrl+Alt+F9 keys clicked
Trial 4: F2+Enter keys clicked on the formula cell
Trial 5: Closed the entire Excel program and reopened
Trial 6: Confirmed that sheet/workbook protection options are not
activated

None of them worked successfully.

How can I have correct result displayed for the formula?
Would appreciate your help.

Thanks,
Guy

 

[Niek Otten]

Format your cell as General

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| A simple calculation formula result is not displayed correctly.
|
| Formula: "=3+3"
| Expected result: 6
| Displayed result: 0
|
| This failure occurs only in one particular sheet among all the sheets
| of a workbook.
| If I select the formula from the formula bar and click F9, I can see
| number 6.
| But once I come out of the cell by clicking ESC button, the formula
| displays number 0.
|
| Several trials have been made to get the expected result.
|
| Trial 1: Tools >> Option >> Automatic (calculation option) selected
| Trial 2: F9 key clicked
| Trial 3: Ctrl+Alt+F9 keys clicked
| Trial 4: F2+Enter keys clicked on the formula cell
| Trial 5: Closed the entire Excel program and reopened
| Trial 6: Confirmed that sheet/workbook protection options are not
| activated
|
| None of them worked successfully.
|
| How can I have correct result displayed for the formula?
| Would appreciate your help.
|
| Thanks,
| Guy
|

 

[guy.yeon]

Hi Thanks for the advice.

I had tried that too but it didn't work.

Thanks,
Guy

 

[Guest]

What happen if you try a different cell?

 

[Gord Dibben]

Format as General then F2 and ENTER.

If you have a great lot of these, copy an empty cell and select the great lot of
cells and Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP