Home

cell shows formula

%3CLINGO-SUB%20id%3D%22lingo-sub-292443%22%20slang%3D%22en-US%22%3Ecell%20shows%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292443%22%20slang%3D%22en-US%22%3E%3CP%3EColumn%20A%26nbsp%3B%3C%2FP%3E%3CP%3E1511208013000%3C%2FP%3E%3CP%3EColumn%20B%20has%20formula%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3Dleft(A2%2C4)%3C%2FP%3E%3CP%3EI%20can%20also%20use%20%3Dmid%20or%20%3Dright%20and%20column%20B%20shows%20literally%20the%20formula%20not%20the%20result%20which%20should%20be%201511%3C%2FP%3E%3CP%3Eany%20ideas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-292443%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20-%20formulas%20data%20worksheet%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292520%22%20slang%3D%22en-US%22%3ERe%3A%20cell%20shows%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292520%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F247307%22%20target%3D%22_blank%22%3E%40WHIT2%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%26nbsp%3Byour%20spreadsheet%20in%20formula%20mode%3F%20Press%20%3CSTRONG%3ECtrl%20%2B%20%60%3C%2FSTRONG%3E%20(left%20of%20the%20number%201%20key)%20and%20see%20if%20that%20helps!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-442187%22%20slang%3D%22en-US%22%3ERe%3A%20cell%20shows%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-442187%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F247307%22%20target%3D%22_blank%22%3E%40WHIT2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Make%20sure%20that%20the%20cell%20format%20not%20in%20'Text'%20and%20should%20be%20'General'.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20If%20still%20you%20have%20problem%2C%20Press%20'Ctrl%20%2B%20%60'%3C%2FP%3E%3C%2FLINGO-BODY%3E
WHIT2
New Contributor

Column A 

1511208013000

Column B has formula: 

=left(A2,4)

I can also use =mid or =right and column B shows literally the formula not the result which should be 1511

any ideas

2 Replies

Hi @WHIT2

 

Do you have your spreadsheet in formula mode? Press Ctrl + ` (left of the number 1 key) and see if that helps!

 

Cheers

Damien

@WHIT2 

 

1. Make sure that the cell format not in 'Text' and should be 'General'.  

2. If still you have problem, Press 'Ctrl + `'