SOLVED
Home

Excel Mac - formula

%3CLINGO-SUB%20id%3D%22lingo-sub-389689%22%20slang%3D%22en-US%22%3EExcel%20Mac%20-%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389689%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20help!%3C%2FP%3E%3CP%3EI%20have%20written%20a%20formula%20in%20a%20cell%20in%20excel%20(for%20Mac)%2C%20but%20it%20does%20not%20return%20the%20value%20when%20I%20push%20enter%20after%20formula.%20It%20only%20remain%20formula%2C%20does%20not%20give%20the%20%22sum%22%20or%20answer%20in%20the%20cell.%20And%20I%20know%20the%20formula%20is%20correct%20from%20another%20document.%20It%20seems%20like%20something%20is%20%22turned%20off%22%20regards%20turning%20the%20formula%20in%20itself%20into%20the%20answer%20to%20the%20formula......%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-389689%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391434%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Mac%20-%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391434%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20soooo%20much!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389876%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Mac%20-%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304662%22%20target%3D%22_blank%22%3E%40johassa%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20see%20the%20formula%2C%20not%20calculation%20result%2C%20your%20cell%20is%20formatted%20as%20text.%20Apply%20General%20format%20to%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
johassa
New Contributor

Please help!

I have written a formula in a cell in excel (for Mac), but it does not return the value when I push enter after formula. It only remain formula, does not give the "sum" or answer in the cell. And I know the formula is correct from another document. It seems like something is "turned off" regards turning the formula in itself into the answer to the formula......

2 Replies
Solution

@johassa , if you see the formula, not calculation result, your cell is formatted as text. Apply General format to it.

@Sergei Baklan 

 

Thank you soooo much! :)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies