![]() |
Formulas
I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help
|
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 |
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 |
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 |
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