S Shobhit jain Nov 20, 2009 #1 I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help
R RonaldoOneNil Nov 20, 2009 #2 Is the cell that you are entering the formula into formatted as text instead of general ?
D David Biddulph Nov 20, 2009 #3 If you need to change the format to text, you'll then ned to re-enter the formula (F2 to get into formula edit mode, then enter).
If you need to change the format to text, you'll then ned to re-enter the formula (F2 to get into formula edit mode, then enter).
M Ms-Exl-Learner Nov 20, 2009 #4 Just press the Cntrl+Tilde button (~) The Tilde Button will be available above the Left Tab Button. If this post helps, Click Yes!
Just press the Cntrl+Tilde button (~) The Tilde Button will be available above the Left Tab Button. If this post helps, Click Yes!
W warrior mani Nov 21, 2009 #5 I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help Click to expand... Just go to the TOLLS -> OPTIONS -> VIEW TAB -> under "WINDOW OPTIONS" -> UNCHECK THE FORMULAS. THATS ALL... Regards, Mani.V
I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help Click to expand... Just go to the TOLLS -> OPTIONS -> VIEW TAB -> under "WINDOW OPTIONS" -> UNCHECK THE FORMULAS. THATS ALL... Regards, Mani.V