ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/248978-formulas.html)

Shobhit jain

Formulas
 
I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help

RonaldoOneNil

Formulas
 
Is the cell that you are entering the formula into formatted as text instead
of general ?

"Shobhit jain" wrote:

I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help


David Biddulph[_2_]

Formulas
 
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).
--
David Biddulph

"RonaldoOneNil" wrote in message
...
Is the cell that you are entering the formula into formatted as text
instead
of general ?

"Shobhit jain" wrote:

I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help




Ms-Exl-Learner

Formulas
 
Just press the Cntrl+Tilde button (~)

The Tilde Button will be available above the Left Tab Button.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Shobhit jain" wrote:

I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help


warrior mani

Formulas
 
On Nov 20, 3:05*pm, Shobhit jain <Shobhit
wrote:
I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help


Just go to the TOLLS - OPTIONS - VIEW TAB - under "WINDOW
OPTIONS" - UNCHECK THE FORMULAS.

THATS ALL...


Regards,

Mani.V


All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com