Performing any calculation in excel

New Contributor


I have recently purchased a new office package.

When I work on the excel platform the mathematics calculation does not work.

The print   "=5*10"   remains inside the cell after enter is hit.

When I turn to the Format Cell window, at the Number Tab in the Sample display window I see the correct answer. 

I hope you can help me understand why this is happening.



4 Replies
If the cell was formatted as text and you changed it to something else (general/number), then you usually have to re-confirm by clicking in the formula bar and hitting enter again.

If that's not the problem, then the only other thing I can suggest is to verify the "show formulas" button is not turned on (formulas tab, formula auditing group, show formulas toggle button).



Thank you very much for the help.

It worked.



You are welcome.