![]() |
when i type a formula in excel i can see the formula only
can somebody help me its urgent please
|
when i type a formula in excel i can see the formula only
In Excel 2003 go to Tools-Options-View Tab
Uncheck the 'Formulas' checkbox in the Windows Options block... OR You can press (once only) CTRL-~ keys together :-) "Santhosh" wrote: can somebody help me its urgent please |
when i type a formula in excel i can see the formula only
On my keyboard it is Ctrl `, not Ctrl ~
Another possible explanation is that the cell may be formatted as text. If so, format as general and then re-enter the formula. -- David Biddulph "Sheeloo" wrote in message ... In Excel 2003 go to Tools-Options-View Tab Uncheck the 'Formulas' checkbox in the Windows Options block... OR You can press (once only) CTRL-~ keys together :-) "Santhosh" wrote: can somebody help me its urgent please |
when i type a formula in excel i can see the formula only
You are right, David. My mistake...
"David Biddulph" wrote: On my keyboard it is Ctrl `, not Ctrl ~ Another possible explanation is that the cell may be formatted as text. If so, format as general and then re-enter the formula. -- David Biddulph "Sheeloo" wrote in message ... In Excel 2003 go to Tools-Options-View Tab Uncheck the 'Formulas' checkbox in the Windows Options block... OR You can press (once only) CTRL-~ keys together :-) "Santhosh" wrote: can somebody help me its urgent please |
All times are GMT +1. The time now is 11:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com