Performing any calculation in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1585892%22%20slang%3D%22en-US%22%3EPerforming%20any%20calculation%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585892%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20recently%20purchased%20a%20new%20office%20package.%3C%2FP%3E%3CP%3EWhen%20I%20work%20on%20the%20excel%20platform%20the%20mathematics%20calculation%20does%20not%20work.%3C%2FP%3E%3CP%3EThe%20print%26nbsp%3B%20%26nbsp%3B%22%3D5*10%22%26nbsp%3B%20%26nbsp%3Bremains%20inside%20the%20cell%20after%20enter%20is%20hit.%3C%2FP%3E%3CP%3EWhen%20I%20turn%20to%20the%20Format%20Cell%20window%2C%20at%20the%20Number%20Tab%20in%20the%20Sample%20display%20window%20I%20see%20the%20correct%20answer.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20can%20help%20me%20understand%20why%20this%20is%20happening.%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EAsher%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1585892%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1585906%22%20slang%3D%22en-US%22%3ERe%3A%20Performing%20any%20calculation%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585906%22%20slang%3D%22en-US%22%3EIf%20the%20cell%20was%20formatted%20as%20text%20and%20you%20changed%20it%20to%20something%20else%20(general%2Fnumber)%2C%20then%20you%20usually%20have%20to%20re-confirm%20by%20clicking%20in%20the%20formula%20bar%20and%20hitting%20enter%20again.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20that's%20not%20the%20problem%2C%20then%20the%20only%20other%20thing%20I%20can%20suggest%20is%20to%20verify%20the%20%22show%20formulas%22%20button%20is%20not%20turned%20on%20(formulas%20tab%2C%20formula%20auditing%20group%2C%20show%20formulas%20toggle%20button).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1586025%22%20slang%3D%22en-US%22%3ERe%3A%20Performing%20any%20calculation%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586025%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20the%20help.%3C%2FP%3E%3CP%3EIt%20worked.%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EAsher%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1586032%22%20slang%3D%22en-US%22%3ERe%3A%20Performing%20any%20calculation%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586032%22%20slang%3D%22en-US%22%3ENice%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1586910%22%20slang%3D%22en-US%22%3ERe%3A%20Performing%20any%20calculation%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586910%22%20slang%3D%22en-US%22%3EYou%20are%20welcome.%3C%2FLINGO-BODY%3E
New 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.