Performing any calculation in excel

Copper Contributor

Hello,

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.

Regards,

Asher

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).

@JMB17 

 

Thank you very much for the help.

It worked.

Regards,

Asher

Nice
You are welcome.