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